Replacing sheet reference in multiple cells...

  • Thread starter Thread starter neilcarden
  • Start date Start date
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
 
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
 
You may want to look at Edit > Links as an alternative to Replace. I find it
works easier than Replace in some cases.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Question 2
How to separate id and name from column 5
Auto return month as text date 1
Match and delete rows on two different sheets from reference numbers 4
Sheet Referencing - autofilling sheet names 2
Formulas That Reference ADJACENT Sheet 4
Formula for Next Sheet and Every Other Cell 12
use month in cell date to sum all relevant cells 2

Back
Top