Replace cell letter

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
 
J

Jacob Skaria

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

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

MATCH 2
Fill formula down for cells 74 rows apart 3
Lookup formula 6
Formula Help Please 5
SUMIF function and cell /sheet reference 3
How to use vlookup in an array formula 2
Macro to replace in two worksheets 5
Copy cell from sheet2 2

Top