Forum Discussion
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...
Camilo1986 If you happen to be on the latest version Excel, the attached workbook contains an example that will work for you. Using a structured table of in Sheet1 and one formulae in A1 on Sheet2 that references all of the first three columns of the table in Sheet1 at once. Add records at the bottom in Sheet1 and the list in Sheet2 expands with it.
- Thanks for the very fast response Riny! Wasn't expecting this to have such a quick resolution.
