I need someone with excel service to help me. I need a stock and invetory excel spread-sheet for a small retail-shop. It will record all stock currently in the retail shop when someone buys something everything is auotmatically update (e.g the inventory list is reduced significantly). The spreadsheet will also alert me when to place order for new stock when i reach a threshold quantity. It should also calculate profiit etc... any excell experts PM with your offer ?
Basically what i need the spreadsheet will be something as i described below: VLookup will connect the quantity with the warnings in second worksheet for inventory. I need to data validate the item sold in the daily sales worksheet, instead for me to type the word i will only click on the drop-down list, e.g when someone buys butter instead of me typing butter i will just click the drop-down list and it will automatically bring the name of the item (butter) and I will enter the quantity sold which is 1 , as soon as i enter the quantity it will automatically calculate the amount and the profit. This calculation will also connect to sheet 2 of the inventory which it will also be updated. I need the layout to be like this below, it is the daily sales record spreadsheet. SHEET1 The second worksheet layout should at least contain these below, it is the worksheet which contains the inventory list which will alert if need to re-order stock (re-stock). When item 1 butter is sold as recorded in sheet one the sheet 2 also is updated. Quantity left will be subtracted with Quantity sold so that we know if we need to re-stock. Obviously there will be a threshold amount of quantity that should be always left in stock. In Sheet2 the column wholesale price is there to calculate the profit in sheet1 Wholesale price less Retail Price = Profit