| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Odd Excel 2007 behavior: copied chart linked to source sheet | Charts and Charting in Excel | |||
| sort source data sheet while destination shows same data | Excel Worksheet Functions | |||
| sort source workbook data, maintain formulas in destination workb. | Excel Worksheet Functions | |||
| Delete the formulas of webpage, copied & pasted on excel sheet | Excel Discussion (Misc queries) | |||
| Hyperlinks - identifying source in destination sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
