colinheslop1984
Board Regular
- Joined
- Oct 14, 2016
- Messages
- 129
- Office Version
- 2016
I am building a rota and so have 52 work sheets titled week1, week2, etc...
each sheet is identical in layout, similar to below. Assume that cells here run from A1:O5
What I want to do is have all the dates update across the 52 sheets when I enter the 'start' date in week1
Currently I am just doing by d1=b1+1, f1=d1+1 and so on, then starting week2 with b1='week1'!n1+1 and so on but this is so time consuming.
Is there a simpler way?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]02-jun[/TD]
[TD]hrs worked[/TD]
[TD]03-jun[/TD]
[TD]hrs worked[/TD]
[TD]04-jun[/TD]
[TD]hrs worked[/TD]
[TD]05-jun[/TD]
[TD]hrs worked[/TD]
[TD]06-jun[/TD]
[TD]hrs worked[/TD]
[TD]07-jun[/TD]
[TD]hrs worked[/TD]
[TD]08-jun[/TD]
[TD]hrs worked[/TD]
[/TR]
[TR]
[TD]name[/TD]
[TD]9-6[/TD]
[TD]8[/TD]
[TD]11-9[/TD]
[TD]8[/TD]
[TD]DO[/TD]
[TD][/TD]
[TD]DO[/TD]
[TD][/TD]
[TD]9-6[/TD]
[TD]8[/TD]
[TD]9-6[/TD]
[TD]8[/TD]
[TD]9-6[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
each sheet is identical in layout, similar to below. Assume that cells here run from A1:O5
What I want to do is have all the dates update across the 52 sheets when I enter the 'start' date in week1
Currently I am just doing by d1=b1+1, f1=d1+1 and so on, then starting week2 with b1='week1'!n1+1 and so on but this is so time consuming.
Is there a simpler way?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]02-jun[/TD]
[TD]hrs worked[/TD]
[TD]03-jun[/TD]
[TD]hrs worked[/TD]
[TD]04-jun[/TD]
[TD]hrs worked[/TD]
[TD]05-jun[/TD]
[TD]hrs worked[/TD]
[TD]06-jun[/TD]
[TD]hrs worked[/TD]
[TD]07-jun[/TD]
[TD]hrs worked[/TD]
[TD]08-jun[/TD]
[TD]hrs worked[/TD]
[/TR]
[TR]
[TD]name[/TD]
[TD]9-6[/TD]
[TD]8[/TD]
[TD]11-9[/TD]
[TD]8[/TD]
[TD]DO[/TD]
[TD][/TD]
[TD]DO[/TD]
[TD][/TD]
[TD]9-6[/TD]
[TD]8[/TD]
[TD]9-6[/TD]
[TD]8[/TD]
[TD]9-6[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]