Replacing sheet reference in multiple cells...

N

neilcarden

Hi,

I have a sheet with an 'April' column of data referencing cells in an
'Apr06' sheet... Next to that column I have the 'May' one, which I want
to reference cells in 'May06' sheet. I have dragged the formula along
with $C$5 for example, so the cells are correct, but is there anyway I
can replace the Apr06 reference with May06 in one fail swoop??

Thanks
 
P

Pete_UK

Highlight the column that you want to change and then CTRL-H (Find &
Replace). In the dialogue box enter:

Find What: Apr06!
Replace With: May06!

then click Replace All.

Hope this helps.

Pete
 
L

lk

You may want to look at Edit > Links as an alternative to Replace. I find it
works easier than Replace in some cases.
 
Top