BJRobinson Posted April 13, 2018 Share Posted April 13, 2018 Hi. Can anyone let me know how to add another category, 'Cactus/Succulents' to this table please. Quote Link to comment
Pat Stanford Posted April 13, 2018 Share Posted April 13, 2018 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. 1 Quote Link to comment
BJRobinson Posted April 14, 2018 Author Share Posted April 14, 2018 (edited) 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'! Quote Link to comment
BJRobinson Posted April 14, 2018 Author Share Posted April 14, 2018 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 :-) Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.