Forum Discussion
Camilo1986
Apr 21, 2020Copper Contributor
Linking two spread sheets and update
Hi all, I have been struggling with what would appear to be a simple taks. I have one Master table with numerous rows and columns. On the second Sheet I want to copy all the values in the all the...
morgan_young
Oct 27, 2022Copper Contributor
I am having a similar issue, I have a master sheet with all names, start dates and dates of birth among another information. On sheet 2 I just want the name, start date and DOB to automatically update. i have used the formula ='Staff Master - Alpha'!A4 to populate this, but when ever i add a new column to sheet 1 it doesnt update on sheet 2 unless i go an manually add that column in. I just want it to automatically add those columns in/remove them when we delete them without me having to do anything to the second sheet.