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...
Beside Riny's response below, I just figured out another way with relative referencing.
=Index('Sheet1!1'A:A,row())
Works as well! Hope someone finds this answer useful as well!
Camilo1986 Indeed, that will work as well. Even a simple =Sheet1!A1:C1 and copy it down as far as needed. But neither of these resize automatically with changes in Sheet1.
