simplysoph
New Member
- Joined
- Jul 5, 2022
- Messages
- 1
- Office Version
- 2010
- Platform
- Windows
I have three spreadsheets I am hoping to link to one main one, with the dates and 3 locations (FH, SH, WTN) down the rows, and variables along the columns.
Master with linked data:
Data spreadsheet 1/3
On the summary spreadsheet, I can link the data for the first location (eg. in C4), but then when I remove the $ on the row, then paste it for the next date (eg. cell C7), it skips rows and ends up at B7.
eg.
it sounds like it may be doable with MOD or OFFSET? Any help would be much appreciated
Master with linked data:
Data spreadsheet 1/3
On the summary spreadsheet, I can link the data for the first location (eg. in C4), but then when I remove the $ on the row, then paste it for the next date (eg. cell C7), it skips rows and ends up at B7.
eg.
it sounds like it may be doable with MOD or OFFSET? Any help would be much appreciated
