Bryan G. 32 Posted April 4, 2008 I am trying to generate a plant list that separates out and lists my information in groups such as annuals, perennials,shrubs, trees. I get one master list of all plants alphabetically, I do get that I can append another list but I need to know how to separate the plant types. And as another note I get the column totals on the top and cannot seem to get rid of them anyone have any help. Quote Share this post Link to post
Pat Stanford 1,450 Posted April 4, 2008 I don't have time right now to mess with the plant lists, but the column total can be hidden by unchecking the option (from the small triangle pull down menu above the column headers) that says Database Headers. With Database Headers selected, you get the total (or count for non-numeric cells) of the column. You can also select a cell in the header row and add/edit the formula for the column. With Database Headers off, you don't see the totals and can't edit the formulas. Pat Quote Share this post Link to post
Bryan G. 32 Posted April 4, 2008 Thanks Pat, that helps with that little issue. I definetly would like to know more about the worksheets and how to manipulate data. I am playing with it now but would love some pointers on them if you ever get a chance. Quote Share this post Link to post
Quattro 0 Posted June 24, 2008 G'Day, I to am trying to setup a similar database. I would like to seperate the category's of plant into tree, shrub, ground cover. Have you had any luck yet. So far all i have been able to do is enter the information in manually and then create a formula to count each instance for a quantity. Mike Quote Share this post Link to post
PVA - Jim 2,383 Posted June 30, 2008 The following Video Tech Tip covers this topic. http://download2.nemetschek.net/TechTips/Organizing_Worksheets/Organizing_Worksheets.html Quote Share this post Link to post