[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
<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