I have been given a task to create an inventory sheet for my place of work.  For my inventory task, I have completed the inventory by building. I also need to create a separate inventory sheet by category as well. I was wondering if it would be possible to use the drop-down menu to automatically add a row to a new worksheet?

For instance, I have 10 scissors in the East Building. This is office supplies. Could I use a dropdown menu to designate this as office supplies and have the row with scissors be automatically added to another workbook designated to office supplies? The row also included info like cost, link to where to buy, etc. I am hoping that this is a possibility, and that if we update the original workbook to reflect a different number of scissors the office supply workbook would be updated as well. I am new to excel and am having difficulty finding which formulas would work best for this scenario

​I have been given a task to create an inventory sheet for my place of work.  For my inventory task, I have completed the inventory by building. I also need to create a separate inventory sheet by category as well. I was wondering if it would be possible to use the drop-down menu to automatically add a row to a new worksheet? For instance, I have 10 scissors in the East Building. This is office supplies. Could I use a dropdown menu to designate this as office supplies and have the row with scissors be automatically added to another workbook designated to office supplies? The row also included info like cost, link to where to buy, etc. I am hoping that this is a possibility, and that if we update the original workbook to reflect a different number of scissors the office supply workbook would be updated as well. I am new to excel and am having difficulty finding which formulas would work best for this scenario  Read More

​