| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Cell References To a Different Worksheet in the Same Cell
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
| Cell Reference's when Pasting | Excel Discussion (Misc queries) | |||
| changing cell references | Excel Discussion (Misc queries) | |||
| Cell References and External Data | Excel Worksheet Functions | |||
| Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Threaded Mode
