Replace cell letter
 

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

Replace cell letter
 

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

--
Jacob


"johnc" wrote:

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