Dicegoddess
New Member
- Joined
- Mar 3, 2009
- Messages
- 1
I have a list of employees and their scheduled start times. I need to take that paticular master list and break it down into another spread sheet by their assignmet, name, start time and each shift having their own column.
Example:Master List
Friday Saturday etc.....
Employee Name Start Time
Bunny B 0900
Doe J 0900
Duck D 1600
Mouse M 0900
Fudd E 1900
Results needed in another sheet:
Days Swing
Assingment Employee Start Assingment Employee Start
SH106 Doe J 9 MB Duck D 1600
SH102 Bunny B 9 Sh201 Fudd E 1900
LI101 Mouse M 9
I want it to automatically update to the other sheet when the master sheet is revised. Im unable to index this from smallest to largest on results sheet. Do I need some type of IF statements?
Thank you, In advance
Example:Master List
Friday Saturday etc.....
Employee Name Start Time
Bunny B 0900
Doe J 0900
Duck D 1600
Mouse M 0900
Fudd E 1900
Results needed in another sheet:
Days Swing
Assingment Employee Start Assingment Employee Start
SH106 Doe J 9 MB Duck D 1600
SH102 Bunny B 9 Sh201 Fudd E 1900
LI101 Mouse M 9
I want it to automatically update to the other sheet when the master sheet is revised. Im unable to index this from smallest to largest on results sheet. Do I need some type of IF statements?
Thank you, In advance