I have a Excel document with 2 tabs. The first one is a “partslist”. The second tab is automatically pulled from company data and refreshed weekly,”Facility”.(this cannot be edited in any way)

What I’m trying to do is have Fac ID column in the Facility tab automatically generate into the partslist table on the Partslist tab. We add facility all the time so manually adding wouldn’t be ideal.

Fac ID Column(Facility tab) -> Spareparts(tab) =generates a column in partslist table, that will automatically add a new column if a new Fac ID is added.

​I have a Excel document with 2 tabs. The first one is a “partslist”. The second tab is automatically pulled from company data and refreshed weekly,”Facility”.(this cannot be edited in any way)What I’m trying to do is have Fac ID column in the Facility tab automatically generate into the partslist table on the Partslist tab. We add facility all the time so manually adding wouldn’t be ideal. Fac ID Column(Facility tab) -> Spareparts(tab) =generates a column in partslist table, that will automatically add a new column if a new Fac ID is added.  Read More

​