Changing Cell References To a Different Worksheet in the Same Cell

[Guest]

I have several spreadsheets which contain calculations based on a master
sheet called FT_Data. I ran the exact same calculations on another dataset
which appear in a sheet called PT_Data. What I need to do is copy the
formulas now referencing FT_Data to another location in the workbook where
they would reference PT_Data in the same cells. Is there a shortcut way to do
this?

 

[David McRitchie]

Hi "DL",
See John Manville's Find Link (addin) on Stephen Bullen's MVP page
http://www.oaltd.co.uk/MVP/Default.htm

 

[Guest]

Ok, so which tool is it? Does it also change relative cell references to
absolute?

 

[David McRitchie]

Misread it thought there were two workbooks involved and you would need to
change a string to another -- if it still there. The addin has the ability to change all
occurrences of a text string of your choice in cells (i.e. anything in a formula or text
constant) to one of your choice such as a change of the worksheetname in the formula.

Changing from relative is absolute was not mentioned, but I guess that refers
to copying do different addresses within the other sheet than the addresses
they came from. .

Changing the worksheet name aside, if you want to copy formulas unchanged
you would copy from the address bar instead of from the cell.

So don't have an answer for you that you can use.