Hi,

I have a Purchase/Sales database that I would like to use a combo box selection that would look up various other worksheets (all identical format) that contain purchases from suppliers, each supplier has their own sheet.

The Sales sheet, which is where I would like the Combo Box that would give me the option to look-up the the suppliers sheets and display the products that i have purchased, then i could select the product that would add the data to my sales and (Product name and Selling Price)

I would then need to add the selling quantity which would deduct this from the total in stock, is this possible in excel, or is this too much to ask.

Cuddle Corner Stock.xlsx