gestionaire
New Member
- Joined
- Mar 15, 2011
- Messages
- 2
Hi!
here is my question. I have a shift schedule made up with excel. The schedule shows, through out the month, when the employees are early shift (E), late shift (L), when they are off (X), when they are on sick leave (SL), sick leave without pay (SLWOP) or leave without pay (LWOP). What i would like to do is have this same schedule printed without the SL, SLWOP, LWOP and have them replaced with an X. When I look at the electronic version of the schedule, I want to be able to see SL, SLWOP... but not on the copy that comes out of the printer. I have tried copying and pasting special (link) but then, on the new excel page, I can't do much since it takes all the information from page 1.
Just so you guys know, I have tried different formulas (IF, REPLACE) but because i wish to keep the original schedule to show the real information, I had to paste linked the entire data into a new sheet. When i try formulas, it keep on giving me errors as it always refer to sheet one where it gets its information from.
I hope my explanations are clear enough. I have been working on this project for a while now and still can't figure out how to do it. The only way I found is to copy and paste linked to Word. Then FINS/Replace all terms mentioned above with X. This is time consuming so I wish this could be done automatically on the print version.
All the help you can provide is much appreciated.
here is my question. I have a shift schedule made up with excel. The schedule shows, through out the month, when the employees are early shift (E), late shift (L), when they are off (X), when they are on sick leave (SL), sick leave without pay (SLWOP) or leave without pay (LWOP). What i would like to do is have this same schedule printed without the SL, SLWOP, LWOP and have them replaced with an X. When I look at the electronic version of the schedule, I want to be able to see SL, SLWOP... but not on the copy that comes out of the printer. I have tried copying and pasting special (link) but then, on the new excel page, I can't do much since it takes all the information from page 1.
Just so you guys know, I have tried different formulas (IF, REPLACE) but because i wish to keep the original schedule to show the real information, I had to paste linked the entire data into a new sheet. When i try formulas, it keep on giving me errors as it always refer to sheet one where it gets its information from.
I hope my explanations are clear enough. I have been working on this project for a while now and still can't figure out how to do it. The only way I found is to copy and paste linked to Word. Then FINS/Replace all terms mentioned above with X. This is time consuming so I wish this could be done automatically on the print version.
All the help you can provide is much appreciated.
