Hello,
I was hoping for a some help with a work problem. I hope it isn't asking too much. We export staff schedules often, and then have to format them and arrange the staff in a particular order. I was hoping there would be a way to automate some or all of this tedious task. I have attached the exported info, as well as what it looks like after we format it. This is one of our smaller schedules, so if someone could point me in the right direction I could hopefully use that info to do the rest of our schedules.
-In the exported file, column A and rows 1-7 should be deleted.
-Any cell with anything other than a shift (VCP, CFM, etc.) should be shaded grey.
-Names without any data for their schedule may be deleted.
-The names need to be arranged in this order, with the rows "TAHD Seniors, Cashiers" etc added in and shaded. The corresponding schedule in the row should follow the name around as they are placed.
-Some names/schedule should be duplicated in certain areas.
If there is an existing thread someone could point me to, or just some general tips I could take a crack at it if this is asking too much. Thanks!
-Sean
I was hoping for a some help with a work problem. I hope it isn't asking too much. We export staff schedules often, and then have to format them and arrange the staff in a particular order. I was hoping there would be a way to automate some or all of this tedious task. I have attached the exported info, as well as what it looks like after we format it. This is one of our smaller schedules, so if someone could point me in the right direction I could hopefully use that info to do the rest of our schedules.
-In the exported file, column A and rows 1-7 should be deleted.
-Any cell with anything other than a shift (VCP, CFM, etc.) should be shaded grey.
-Names without any data for their schedule may be deleted.
-The names need to be arranged in this order, with the rows "TAHD Seniors, Cashiers" etc added in and shaded. The corresponding schedule in the row should follow the name around as they are placed.
-Some names/schedule should be duplicated in certain areas.
If there is an existing thread someone could point me to, or just some general tips I could take a crack at it if this is asking too much. Thanks!
-Sean