| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy formulas from 1 wrkbk to another w/o absolute refs
I am trying to copy a summary from one workbok to another. How do I copy
with out absoute references to the source workbook? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I copy formulas from 1 wrkbk to another w/o absolute refs
Mike
Select the range you want to copy. Then click on Edit - Replace. In the "Find what:" block, type the equal sign "=" (without the quotes). In the Replace with block type some text that you know you don't have in your range, like $$$$$. Click OK. Now all the formulas in your range are no longer formulas. Copy and paste. In the destination sheet, select the range you just pasted. Do Edit - Replace and replace the "$$$$$" with "=". Done. HTH Otto "Mike" wrote in message ... I am trying to copy a summary from one workbok to another. How do I copy with out absoute references to the source workbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formulas to cells absolute rows and variable columns | Excel Discussion (Misc queries) | |||
| Copy formulas via Code | Excel Discussion (Misc queries) | |||
| How do I copy a spreadsheet, keeping the formulas but not the #s | Excel Discussion (Misc queries) | |||
| how do i copy vertical formulas to horizonal and keep same cell r. | Excel Discussion (Misc queries) | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Linear Mode
