Roster with each person getting their own weekly sheet printed
Closed
cobbadan
Posts
5
Registration date
Sunday January 20, 2013
Status
Member
Last seen
January 22, 2013
-
Jan 20, 2013 at 10:35 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 23, 2013 at 06:52 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 23, 2013 at 06:52 AM
Related:
- Roster with each person getting their own weekly sheet printed
- Google sheet right to left - Guide
- Windows network commands cheat sheet - Guide
- How to pin a person in messenger - Guide
- Mark sheet in excel - Guide
- Little alchemy cheat sheet - Guide
5 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 21, 2013 at 08:38 PM
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
Posts
5
Registration date
Sunday January 20, 2013
Status
Member
Last seen
January 22, 2013
Jan 21, 2013 at 09:15 PM
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
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 21, 2013 at 09:20 PM
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
Posts
5
Registration date
Sunday January 20, 2013
Status
Member
Last seen
January 22, 2013
Jan 21, 2013 at 09:26 PM
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
Posts
5
Registration date
Sunday January 20, 2013
Status
Member
Last seen
January 22, 2013
Jan 21, 2013 at 09:27 PM
Jan 21, 2013 at 09:27 PM
A separate macro for each person ?
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 21, 2013 at 09:52 PM
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
Posts
5
Registration date
Sunday January 20, 2013
Status
Member
Last seen
January 22, 2013
Jan 22, 2013 at 12:06 AM
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
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 23, 2013 at 06:52 AM
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