I know my way around excel a bit, but here is my dilemma.
Excel 2004 for Mac.
I have a standard price list from one of my vendors, and I am trying to make it a standardized order form for my reps. I have a column for quantity, and have it to where it calculates the total per items, as well as calculates the grand total at the bottom.
Hooray for me!
Here is my dilemma.
When I am done entering quantities I want to be able to run a report that only has the items ordered. So if I entered a quantity on a certain item, I want it to be displayed, but if the client did not order an item, I do not want it to be displayed.
Is there a way to tell excel to run a report for only the items entered?
Any help would be useful.
Thanks,
A
Bookmarks