Hi!
here is my question. I have a shift schedule made up with excel. The schedule shows 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.

Please help !