RedOctoberKnight
Board Regular
- Joined
- Nov 16, 2015
- Messages
- 153
- Office Version
- 2016
- Platform
- Windows
Good Morning,
I'm currently working on a scheduling tool for work. I have a "Master" sheet that has everybody's name and work schedules for every day of the week. I then have sheets for every day of the schedule period that contains a position assignment and a daily log that get's faxed to our payroll department daily. Example of the daily log below.
[TABLE="width: 500"]
<tbody>[TR]
[TD]last
[/TD]
[TD]first
[/TD]
[TD]EE
[/TD]
[TD]Schedule
[/TD]
[TD]Actual
[/TD]
[TD]SCO
[/TD]
[TD]OT
[/TD]
[TD]DT
[/TD]
[TD]LWOP
[/TD]
[TD]Remarks
[/TD]
[/TR]
[TR]
[TD]Averill
[/TD]
[TD]N
[/TD]
[TD]111
[/TD]
[TD]0430-1300
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]STW 1230-2100 Barnes
[/TD]
[/TR]
[TR]
[TD]Awadallah
[/TD]
[TD]B
[/TD]
[TD]222
[/TD]
[TD]1145-2015
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barnes
[/TD]
[TD]C
[/TD]
[TD]333
[/TD]
[TD]1230-2100
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]STO Averill/STW 1230-2100 Diaz
[/TD]
[/TR]
[TR]
[TD]Bass
[/TD]
[TD]E
[/TD]
[TD]444
[/TD]
[TD]OFF
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Last, First, EE, and Schedule columns are all formulated to pull information off the "Master" sheet. Remarks are simply add daily to that specific sheet. The problem I'm running into is when I add a new employee, and sort alphabetically, the remarks don't remain in the same row as the original employee. So if I add employee last name BAKER, it would sort it in between Awadallah and Barnes. But the comments that are currently in for Barnes would now be on Baker's row. If that makes any sense....
Is there a way to be able to insert a new employee into the "master" sheet and have all the comments for each employee follow them on there respective rows?
Any info would be much appreciated!
Thanks!
I'm currently working on a scheduling tool for work. I have a "Master" sheet that has everybody's name and work schedules for every day of the week. I then have sheets for every day of the schedule period that contains a position assignment and a daily log that get's faxed to our payroll department daily. Example of the daily log below.
[TABLE="width: 500"]
<tbody>[TR]
[TD]last
[/TD]
[TD]first
[/TD]
[TD]EE
[/TD]
[TD]Schedule
[/TD]
[TD]Actual
[/TD]
[TD]SCO
[/TD]
[TD]OT
[/TD]
[TD]DT
[/TD]
[TD]LWOP
[/TD]
[TD]Remarks
[/TD]
[/TR]
[TR]
[TD]Averill
[/TD]
[TD]N
[/TD]
[TD]111
[/TD]
[TD]0430-1300
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]STW 1230-2100 Barnes
[/TD]
[/TR]
[TR]
[TD]Awadallah
[/TD]
[TD]B
[/TD]
[TD]222
[/TD]
[TD]1145-2015
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barnes
[/TD]
[TD]C
[/TD]
[TD]333
[/TD]
[TD]1230-2100
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]STO Averill/STW 1230-2100 Diaz
[/TD]
[/TR]
[TR]
[TD]Bass
[/TD]
[TD]E
[/TD]
[TD]444
[/TD]
[TD]OFF
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Last, First, EE, and Schedule columns are all formulated to pull information off the "Master" sheet. Remarks are simply add daily to that specific sheet. The problem I'm running into is when I add a new employee, and sort alphabetically, the remarks don't remain in the same row as the original employee. So if I add employee last name BAKER, it would sort it in between Awadallah and Barnes. But the comments that are currently in for Barnes would now be on Baker's row. If that makes any sense....
Is there a way to be able to insert a new employee into the "master" sheet and have all the comments for each employee follow them on there respective rows?
Any info would be much appreciated!
Thanks!