Compare Colours

[Hani]

Hello;
I need to write a VBA for excel: Shift Schedule- Compare colour (Blue represent Day, Red represent Night)


1) Four button - Sunday Day, Sunday Nite, Saturday Day, Saturday Nite
When I tick on the button, it will show who is on shift for all the three
spreadsheet shift.
2) One button - Ask for user to key in the date, it will show who is on shift for all the three spreadsheet shift.

Information:

1)The format will follow MG4shiftFY05 so that it will be easier as I know the 3 excel file are all different format, I will standardise the format.
A1:AJ42


2) When I tick the button,
For example Sunday Day :
Line : Magma Team A
Names of the people on shift
Line : N2/N3 Team A
Names of the people on shift
Line : T6/9 Team A
Names of the people on shift

3) When I tick button, Date Selection
Ask user to key in the date : 2
Line : Magma Team C
Names of the people on shift
Line : N2/N3 Team C
Names of the people on shift
Line : T6/9 Team C
Names of the people on shift


Thanks