View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default Changing Cell References To a Different Worksheet in the Same Cell

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

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

"DL" wrote in message ...
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?