Hi all I am new here. I am creating a spreadsheet for inventory for a charity who sells items to help others.
My question is I have not used excel in years and I have made a workbook with 3 sheets, a Master, add Inventory, and Sales. now I have a dummy list of products so that I can just start with formulas. I have tried several formulas and i am just not getting it right.
Firstly I need to add and delete add inventory and sales sheets from the master inventory sheet.
Secondly I would like to auto populate the sales and add inventory sheets with the price when the product is entered
I Would appreciate any help I can get .
Thank you in advance I have also attached this basically empty spreadsheet ss
Bookmarks