Please Help ! Find and Replace data from a linked Excel Sheet !

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.
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

gestionaire

New Member
Joined
Mar 15, 2011
Messages
2
I forgot to mention that I also tried making up a legend like: SL = 1 , SLWOP = 1... using the formula - IF - and I got it working on one column. I would have to repeat the whole formulas for every day of the months, for every employes...

Again, any help you can provide is good help !!!
 

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,876
Members
409,668
Latest member
mitunsLax

This Week's Hot Topics

Top