Chemical Inventory

[Excelbud]

Good morning Everyone,

I have a master list of Chemicals that require a consignment inventory done each month. The master list is kept in a Tab1. From there, I have tabs for each month Jan-Dec. At the start of each month, I copy the Chemical Master list into each month and format according. Is there a way to create a dynamic list of chemicals. Basically, if I add a chemical to the Chemical Master list, it is then added across the tabs. Essentially creating a dynamic list.

Thank you.

 

[tyija1995]

Is the master list in a table? If it is in a table then you can then give the entire column a named range and when you add to the table, the named range will include any added rows. Then you can reference this named range in other tabs