View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dantron Dantron is offline
external usenet poster
 
Posts: 3
Default copied formulas refer to destination sheet not source sheet

In a workbook, with a master sheet copied many times, how do I copy formulas
from one sheet to another and have those formulas refer to the destination
sheet rather than refering back to the source sheet. I seem to remeber this
in the distant past but can't remeber how to make these formulas refer to the
destination sheet and not the source from whence they were copied.