daddyjoe74
New Member
- Joined
- Dec 29, 2016
- Messages
- 2
I apologize if this is posted somewhere else already, I tried searching but not sure how to describe this function so unsure how to search.
I have a spreadsheet for my restaurant's liquor inventory that i was to use to compile the data and turn in for month end inventory.
Column A is the spirit, so vodka, gin, etc. I want all similar column A spirits to be compiled so I can get a total for each spirit on hand. I want all output on the same sheet, not different sheets.
Column D is price, I want price multiplied by on hand which is Column F. I would like all the other column info not mentioned included in the results.
Is it possible that I can have each section total by column A and then a total for all inventory.
There are no spaces in between data on the rows until the end.
Again, I apologize if this is somewhere else, but I didn't know how to search for this.
Are there any websites or books that can help me learn how to program and write my own code instead of asking for help all the time?
thanks,
Russell McGuire
I have a spreadsheet for my restaurant's liquor inventory that i was to use to compile the data and turn in for month end inventory.
Column A is the spirit, so vodka, gin, etc. I want all similar column A spirits to be compiled so I can get a total for each spirit on hand. I want all output on the same sheet, not different sheets.
Column D is price, I want price multiplied by on hand which is Column F. I would like all the other column info not mentioned included in the results.
Is it possible that I can have each section total by column A and then a total for all inventory.
There are no spaces in between data on the rows until the end.
Again, I apologize if this is somewhere else, but I didn't know how to search for this.
Are there any websites or books that can help me learn how to program and write my own code instead of asking for help all the time?
thanks,
Russell McGuire