Roster with each person getting their own weekly sheet printed
Closed
cobbadan
rizvisa1
- Posts
- 5
- Registration date
- Sunday January 20, 2013
- Status
- Member
- Last seen
- January 22, 2013
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Roster with each person getting their own weekly sheet printed
- My personal account was disabled ✓ - Forum - Facebook
- My personal account was locked - Guide
- My personal account was disabled - Forum - Facebook
- My personal account disabled - Forum - Facebook
- My Personal Facebook Account Was Disabled ✓ - Forum - Facebook
5 replies
rizvisa1
Jan 21, 2013 at 08:38 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jan 21, 2013 at 08:38 PM
are you looking to create new rosters or copy the data back to main roster. Either way i think you would be serve best by use of macro
cobbadan
Jan 21, 2013 at 09:15 PM
- Posts
- 5
- Registration date
- Sunday January 20, 2013
- Status
- Member
- Last seen
- January 22, 2013
Jan 21, 2013 at 09:15 PM
Im looking for each staff members weekly roster to be copied from the main roster sheet, which is huge, into their own personal sheet.
Each staff members weekly sheet will then be printed and handed out.
Last week for example, Jon's weekly sheet came out with someone else's shifts on it. I dont know how, i tested everybody's weekly sheet before i gave it to the boss to make sure everybody's weekly sheet was getting the info from the right section of the roster. But somehow, after the boss was finished, it was wrong.
If the boss cut's n paste's into the roster, those entries wont show up on the weekly sheets, they just show up as #ref. If he copy's n paste's its all fine.
Glitches and errors just keep happening. Im not sure how to stop it. So im looking for another way.
Each staff members weekly sheet will then be printed and handed out.
Last week for example, Jon's weekly sheet came out with someone else's shifts on it. I dont know how, i tested everybody's weekly sheet before i gave it to the boss to make sure everybody's weekly sheet was getting the info from the right section of the roster. But somehow, after the boss was finished, it was wrong.
If the boss cut's n paste's into the roster, those entries wont show up on the weekly sheets, they just show up as #ref. If he copy's n paste's its all fine.
Glitches and errors just keep happening. Im not sure how to stop it. So im looking for another way.
rizvisa1
Jan 21, 2013 at 09:20 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jan 21, 2013 at 09:20 PM
macro would be best way
you can generate a good macro template by starting macro recorder, creating one sample roster for an employee and then stopping the macro.
you can generate a good macro template by starting macro recorder, creating one sample roster for an employee and then stopping the macro.
cobbadan
Jan 21, 2013 at 09:26 PM
- Posts
- 5
- Registration date
- Sunday January 20, 2013
- Status
- Member
- Last seen
- January 22, 2013
Jan 21, 2013 at 09:26 PM
Each persons weekly sheet would need to get the information from a different section of the main roster sheet though.
How would you get around that ?
How would you get around that ?
cobbadan
Jan 21, 2013 at 09:27 PM
- Posts
- 5
- Registration date
- Sunday January 20, 2013
- Status
- Member
- Last seen
- January 22, 2013
Jan 21, 2013 at 09:27 PM
A separate macro for each person ?
rizvisa1
Jan 21, 2013 at 09:52 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jan 21, 2013 at 09:52 PM
no one macro for all.
Didn't find the answer you are looking for?
Ask a question
cobbadan
Jan 22, 2013 at 12:06 AM
- Posts
- 5
- Registration date
- Sunday January 20, 2013
- Status
- Member
- Last seen
- January 22, 2013
Jan 22, 2013 at 12:06 AM
Start the macro recorder
Copy person 1's info from the roster sheet and paste into person a's weekly sheet.
copy person 2's info from the roster sheet and paste into person 2's weekly sheet
etc etc.
then just run the macro after the roster has been updated.
Is that the way it would work ?
Copy person 1's info from the roster sheet and paste into person a's weekly sheet.
copy person 2's info from the roster sheet and paste into person 2's weekly sheet
etc etc.
then just run the macro after the roster has been updated.
Is that the way it would work ?
rizvisa1
Jan 23, 2013 at 06:52 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jan 23, 2013 at 06:52 AM
no, the macro you will get from the recorder is to give you a very good template to start work from. that macro then needs to tweaked a bit to make it usable for any and all employee
so
1. start mavro
2.Copy person 1's info from the roster sheet
3 paste into person a's weekly sheet.
4 stop macro
this will give you a general template that can be update to be used for any person
so
1. start mavro
2.Copy person 1's info from the roster sheet
3 paste into person a's weekly sheet.
4 stop macro
this will give you a general template that can be update to be used for any person