Hey everyone,
I've created an excel sheet that references info from multiple different excel files. My problem is now that I've created the formula for Week 1, I also need to copy said formula 52 times down and 6 across.
The formula in question is:
='C:\Users\Person\Dropbox\Work Related Forms\Time Sheets 2016\[Week 1.xls]Time'!$AG$40
The part that I need to change is the Week 1... Week 2.. Week 3 etc.
The usual method of selecting either one or two isn't working for me. Is there a quick and easy way to do this?
I've created an excel sheet that references info from multiple different excel files. My problem is now that I've created the formula for Week 1, I also need to copy said formula 52 times down and 6 across.
The formula in question is:
='C:\Users\Person\Dropbox\Work Related Forms\Time Sheets 2016\[Week 1.xls]Time'!$AG$40
The part that I need to change is the Week 1... Week 2.. Week 3 etc.
The usual method of selecting either one or two isn't working for me. Is there a quick and easy way to do this?