Hi, I am building a 41 week timetable and am hitting an issue with forwarding data from one week to the next. I need to have hours totals so I'm using 3 columns, R, S and T.
R for hours worked that week, S to bring forward the previous week's hours and T to show a running total all hours worked as each week passes.
On week 1,
In column R I'm using =SUM(C6:Q6) for hours worked that week.
with nothing in column S because it's the first week and there is nothing to bring forward.
In column T I used =R6+S6.
My issue is that when I get to week 2, in column S, I tried using =week1!T6 to bring forward the previous week's hours and it didn't work.
I would appreciate any help you can offer with this, thanks in advance.
Davie