Chemical Inventory

Excelbud

New Member
Joined
May 11, 2010
Messages
2
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.
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
766
Office Version
  1. 365
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,487
Messages
5,529,156
Members
409,851
Latest member
Ingar
Top