software

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?

Hi quot;DLquot;,
See John Manville's Find Link (addin) on Stephen Bullen's MVP page
www.oaltd.co.uk/MVP/Default.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;DLquot; gt; wrote in message ...
gt; I have several spreadsheets which contain calculations based on a master
gt; sheet called FT_Data. I ran the exact same calculations on another dataset
gt; which appear in a sheet called PT_Data. What I need to do is copy the
gt; formulas now referencing FT_Data to another location in the workbook where
gt; they would reference PT_Data in the same cells. Is there a shortcut way to do
gt; this?
Ok, so which tool is it? Does it also change relative cell references to
absolute?

quot;David McRitchiequot; wrote:

gt; Hi quot;DLquot;,
gt; See John Manville's Find Link (addin) on Stephen Bullen's MVP page
gt; www.oaltd.co.uk/MVP/Default.htm
gt;
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;DLquot; gt; wrote in message ...
gt; gt; I have several spreadsheets which contain calculations based on a master
gt; gt; sheet called FT_Data. I ran the exact same calculations on another dataset
gt; gt; which appear in a sheet called PT_Data. What I need to do is copy the
gt; gt; formulas now referencing FT_Data to another location in the workbook where
gt; gt; they would reference PT_Data in the same cells. Is there a shortcut way to do
gt; gt; this?
gt;
gt;
gt;

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;DLquot; gt; wrote in message ...
gt; Ok, so which tool is it? Does it also change relative cell references to
gt; absolute?
gt;
gt; quot;David McRitchiequot; wrote:
gt;
gt; gt; Hi quot;DLquot;,
gt; gt; See John Manville's Find Link (addin) on Stephen Bullen's MVP page
gt; gt; www.oaltd.co.uk/MVP/Default.htm
gt; gt;
gt; gt; ---
gt; gt; HTH,
gt; gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt; gt;
gt; gt; quot;DLquot; gt; wrote in message ...
gt; gt; gt; I have several spreadsheets which contain calculations based on a master
gt; gt; gt; sheet called FT_Data. I ran the exact same calculations on another dataset
gt; gt; gt; which appear in a sheet called PT_Data. What I need to do is copy the
gt; gt; gt; formulas now referencing FT_Data to another location in the workbook where
gt; gt; gt; they would reference PT_Data in the same cells. Is there a shortcut way to do
gt; gt; gt; this?
gt; gt;
gt; gt;
gt; gt;