Hello, I have a 10 workbooks that have a sheet for everyday of the financial year (and each Sunday is a summary of the preceeding 6 sheets). I was able to select the first Sunday sheet, and Shift select the last Sunday sheet and update the formulae in a few cells e.g. =SUM('8-JUl-13:13-Jul-13'!B17), without impacting the other sheets (which have data keyed in) and the formula was automatically updating the sum sheet range - so that the next week's formula would be =SUM('15-JUl-13:20-Jul-13'!B17). For some reason, that has stopped working, now the formula pastes into all sheets in the selected range instead of just the summary sheet, and it doesn't change from the original sheet range (8th to the 13th of July).
I am using 2010 version of Excel. Any reasons why it would stop working? I would prefer not have to select each summary sheet manually (52 in each file!).
I am using 2010 version of Excel. Any reasons why it would stop working? I would prefer not have to select each summary sheet manually (52 in each file!).
Last edited:
