Replace cell letter

  • Thread starter Thread starter johnc
  • Start date Start date
J

johnc

Not sure how to explain this, but im looking to save a lot of manual entry.

ie. sheet1 is fetching its data from sheet2 A1:A1000 and displays the data
all over sheet1 to many different cell positions in different columns/rows.
How do I point to new data from sheet2 B1:B1000 by replacing all the cells
"=+Sheet2!A####" to "=+Sheet2!B####" in sheet1 while keeping the same cell
positions??? Hope it makes sense...please HELP!

John
 
Try Ctrl+H to launch Find and Replace dialog..Make sure you select 'Formulas'
in 'LookIn'
 
Back
Top