Home |
Search |
Today's Posts |
#1
|
|||
|
|||
bar inventory
I am setting up a bar inventory sheet.... The information is recorded in the
order it is on the shelf (scotch, vodka, Argentinean reds, California reds.......) however, the shelves are not organized by purveyor. I would like to create a second sheet that separates the data by purveyor, for easier organization for ordering. Currently the Inventory sheet is set up as column A is the purveyor, Column B is the item, and Column C is the amount in inventory. i would like a sheet that contains the information from column B and column C categorized under the appropriate purveyor from column A....I would prefer one sheet with different headings...but individual sheets for each purveyor is okay. Thank You |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I setup invoicing to deduct from inventory? | New Users to Excel | |||
Days of sales in inventory template | Setting up and Configuration of Excel | |||
Creating a Multiple Warehouse Inventory Spreadsheets | Charts and Charting in Excel | |||
Inventory Pricing - running averages | Excel Discussion (Misc queries) | |||
Excel games inventory | Excel Discussion (Misc queries) |