Plant list

[BJRobinson]

Hi.

 

Can anyone let me know how to add another category, 'Cactus/Succulents' to this table please.

 

 

[Pat Stanford]

Each of the sections is a separate database.

 

Right click in one of the database row headers (if 6, not 6.1, 6.2, etc.) and choose Edit Criteria. This will show you what criteria are currently being used in each section. You may need to look at several to figure out what you need to change.

 

Get a couple of empty rows next to each other. Either scroll to the bottom or use the Insert menu to put them where you want the Cactus to go.

Go to the bottom of the two blank rows. Right click in the Row Header and choose Database. Then enter the criteria you need. Go to each of the cells and put in the formula you need for that column. Put the Section Header in the top of the two blank rows.

 

Ask again if you get stuck.

 

I posted a long post a couple of days ago about databases. You might want to read that also.

 

 

[BJRobinson]

Thanks Pat.

 

I originally opened a locked one. I have just found one i can edit.

 

I appreciate your help.

 

your post worksheet creation is something i will tackle if needed down the track.

 

Cheers

Edited April 14, 2018 by BJRobinson
Had 'Boys Look'!

[BJRobinson]

I was able to insert 2 rows. Copy and past 2 of the original rows, then change the wording to 'Cactus/Succulent'. That way I didn't have to worry about all the other stuff :-)