ok So My task is a liquor inventory sheet for my bar. I want to create a sheet (master price sheet) in my workbook with a list of liquor we carry and the price per unit in separate columns. There are 4 other sheets in my workbook that represent the bars and liquor room and the bottles are listed in the order they appear on the shelves to make things quick at inventory time. My goal is to have the master price sheet with costs from my invoices that will populate my count sheets with cost to calculate value of liquor so I dont have to do it on every sheet manually. The value of liquor is an easy formula that I can and have done no problem but Im stumped on the best way to make my cost sheet work for me. keep in mind no 2 sheets have the liquor in the exact same order. Attached is a partial sample of my sheet so far.inventory sheet sample.xlsx
Bookmarks