Bryan G. Posted April 4, 2008 Share 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 Link to comment
Pat Stanford Posted April 4, 2008 Share 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 Link to comment
Bryan G. Posted April 4, 2008 Author Share 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 Link to comment
Quattro Posted June 24, 2008 Share 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 Link to comment
Vectorworks, Inc Employee PVA - Admin Posted June 30, 2008 Vectorworks, Inc Employee Share Posted June 30, 2008 The following Video Tech Tip covers this topic. http://download2.nemetschek.net/TechTips/Organizing_Worksheets/Organizing_Worksheets.html 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.