Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy formulas between workbooks w/0 referencing source?
I am struggling to copy math formulas from one workbook to another. I only
want the formulas to reference specific sheets in the active workbook. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to copy formulas between workbooks w/0 referencing source?
Are you saying that you want to copy the cells and keep the formulas
referencing the same cells? If so one way would be to replace the equal sign and copy the text string of the formula then reverse the replace Ctrl h, find what put = replace with put ^=^ replace all, copy over the data, then reverse and replace ^=^ with = in both places -- Regards, Peo Sjoblom "vintagebuilding" wrote in message ... I am struggling to copy math formulas from one workbook to another. I only want the formulas to reference specific sheets in the active workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy and paste formulas between workbooks? | Excel Discussion (Misc queries) | |||
Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
How do I copy & paste formulas without them linking to the source | Excel Discussion (Misc queries) | |||
Copy worksheets with formulas between different workbooks | Excel Discussion (Misc queries) | |||
Referencing workbooks | New Users to Excel |