Shows current days column from one schedule to another sheet updating daily

comic

Board Regular
Joined
Dec 11, 2012
Messages
72
[TABLE="width: 42"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[TABLE="width: 42"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[TABLE="width: 297"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] September 2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Deborah[/TD]
[TD]L[/TD]
[TD]BK2[/TD]
[TD]BK1[/TD]
[TD]Off[/TD]
[TD]MC1[/TD]
[/TR]
[TR]
[TD]Mel[/TD]
[TD]BK1[/TD]
[TD]HOL[/TD]
[TD]HOL[/TD]
[TD]BK2[/TD]
[TD]BK1[/TD]
[/TR]
[TR]
[TD]Tracey Anne[/TD]
[TD]BK2[/TD]
[TD]BK2[/TD]
[TD]BK1[/TD]
[TD]BK1[/TD]
[TD]Off[/TD]
[/TR]
[TR]
[TD]Sarah[/TD]
[TD]Off[/TD]
[TD]L[/TD]
[TD]BK2[/TD]
[TD]L[/TD]
[TD]L[/TD]
[/TR]
</tbody><colgroup><col><col><col><col span="3"></colgroup>[/TABLE]

Month is A2
Employees from is A5
Days of the Week start from B3
Dates from B4

This is part of a monthly employee shift roster. Dates automatically change when the Month (A2)is updated.
I have a main sheet INTERFACE with hyperlinks to this and other schedules and info. The hyperlinks work fine.

What I would like is a piece of code that would show ONE column from the schedule on to the INTERFACE sheet . That ONE column would be for the current date so that every day I open the INTERFACE sheet I would see the current shifts. I know all I have to do is click the hyperlink but that gives me the whole schedule and just having the current column on the INTERFACE would be really convenient. I would have to have the column dynamic should a shift change and I have to update the monthly schedule.
The current area of the monthly schedule is A3:AE24

Many thanks

The monthly schedule covers
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,223,320
Messages
6,171,433
Members
452,402
Latest member
siduslevis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top