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 |
Using your existing sheet, you can add an Auto fiter, and then select the
purveyor you want to view. That is the quickest and easiest way Make sure you have labels in Row 1, eg PURVEYOR, TYPE, QTY. With your cursor on A1, ckick on Data|Filter|Autofilter. Now click on the down arrow next to PURVEYOR, select the purveyor you want to work with, and voila "Peets" wrote: 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 |
thank you very much
"Kassie" wrote: Using your existing sheet, you can add an Auto fiter, and then select the purveyor you want to view. That is the quickest and easiest way Make sure you have labels in Row 1, eg PURVEYOR, TYPE, QTY. With your cursor on A1, ckick on Data|Filter|Autofilter. Now click on the down arrow next to PURVEYOR, select the purveyor you want to work with, and voila "Peets" wrote: 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 |
Glad I could be of assistance! Thanks for the response
"peets" wrote: thank you very much "Kassie" wrote: Using your existing sheet, you can add an Auto fiter, and then select the purveyor you want to view. That is the quickest and easiest way Make sure you have labels in Row 1, eg PURVEYOR, TYPE, QTY. With your cursor on A1, ckick on Data|Filter|Autofilter. Now click on the down arrow next to PURVEYOR, select the purveyor you want to work with, and voila "Peets" wrote: 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 |
All times are GMT +1. The time now is 01:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com