I want to link cells in 1 sheet to different cells in another sheet. I want this to happen automatically i.e. if data in sheet 1 is changed it will automatically change in sheet 2. I want to know the best way to do this.
For example sheet 1:
Row 1: Name Handicap Index (A1,A2 A3)
On sheet 2 I want this to appear as say : D1,D5,D6.
Then I want this to happen for say 40 rows or more ( I need to be able to expand it down if needed).
I tried to do this on Row 1 using Copy> Paste Link and it works for that row. However, I can't copy the individual formulaes down through multiple rows and columns and if I delete the data on sheet 1 row 1 it stays on sheet 2. I do want to be able to copy Sheet 2 also. So think there must be a better way.