Compare Colours
 

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


+-------------------------------------------------------------------+
|Filename: Doc3.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3953 |
+-------------------------------------------------------------------+

--
Hani
------------------------------------------------------------------------
Hani's Profile: http://www.excelforum.com/member.php...o&userid=28380
View this thread: http://www.excelforum.com/showthread...hreadid=479688