Excel Inventory Log help

Occasional Visitor

How to create a workbook that has a log worksheet with multiple dependent drop down lists and depending on what is selected on those lists the quantity entered on the log will then auto-populate to a different work sheet?

 

i.e. List1 "Guns" and "Roses". List2 "Small, Medium, Large" or "Red, White, Blue".

 

Then a user chooses "Guns" and "Small" and has to enter a quantity. Now I have a spreadsheet for Guns and a separate spreadsheet for Roses.

 

How can I have excel automatically send the new quantity to the right spreadsheet?

 

This is an inventory log that multiple users will have access to.

Much thanks!!

 

Log.jpgRaw Data.jpgGuns.jpgRoses.jpg

 

0 Replies