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