I am trying to increment an absolute cell reference in an Excel spreadsheet column.
What I want to be able to do is increment the absolute cell reference by 7 reslutling in increasing each row number by 7 starting with
='[XOM January 2013 Triage Team Metrics.xlsx]Africa Jan 2013'!$J$5
resulting in the following concecutive rows
='[XOM January 2013 Triage Team Metrics.xlsx]Africa Jan 2013'!$J$12
='[XOM January 2013 Triage Team Metrics.xlsx]Africa Jan 2013'!$J$19
='[XOM January 2013 Triage Team Metrics.xlsx]Africa Jan 2013'!$J$26
etc.
I have multiple rows and columns. Any ideas would be appreciated.
Bookmarks