| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formula to new workbook without [REFERENCE]
I need to copy a whole series (3x30 range) of formulae from one workbook to
another. I'd like to copy without the reference to the original workbook. Is this possible? signed: frustrated... -- Adios, Clay Harryman |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy formula to new workbook without [REFERENCE]
What I do for simplicity's sake:
Copy all the formulas over Go into the address bar for one of the cells. Copy everything from the initial ' to the second ' get out of the cell Edit/Find/Replace Paste what you copied in the find Replace with blank OR, if reference is to a different tab, replace with tab name. "Clayman" wrote: I need to copy a whole series (3x30 range) of formulae from one workbook to another. I'd like to copy without the reference to the original workbook. Is this possible? signed: frustrated... -- Adios, Clay Harryman |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy formula to new workbook without [REFERENCE]
HOT DIGGITY!
That did the trick! Thanks! Here I was trying to be too complex.... -- Adios, Clay Harryman "Sean Timmons" wrote: What I do for simplicity's sake: Copy all the formulas over Go into the address bar for one of the cells. Copy everything from the initial ' to the second ' get out of the cell Edit/Find/Replace Paste what you copied in the find Replace with blank OR, if reference is to a different tab, replace with tab name. "Clayman" wrote: I need to copy a whole series (3x30 range) of formulae from one workbook to another. I'd like to copy without the reference to the original workbook. Is this possible? signed: frustrated... -- Adios, Clay Harryman |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy formula to new workbook without [REFERENCE]
To use Excel, you need to be a buddhist. Imagine the sound of one hand
clapping. :-) Thanks for the feedback... "Clayman" wrote: HOT DIGGITY! That did the trick! Thanks! Here I was trying to be too complex.... -- Adios, Clay Harryman "Sean Timmons" wrote: What I do for simplicity's sake: Copy all the formulas over Go into the address bar for one of the cells. Copy everything from the initial ' to the second ' get out of the cell Edit/Find/Replace Paste what you copied in the find Replace with blank OR, if reference is to a different tab, replace with tab name. "Clayman" wrote: I need to copy a whole series (3x30 range) of formulae from one workbook to another. I'd like to copy without the reference to the original workbook. Is this possible? signed: frustrated... -- Adios, Clay Harryman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference Cells from other Workbook to complete Formula | Excel Discussion (Misc queries) | |||
| workbook/cell reference w/ formula | Excel Worksheet Functions | |||
| Copy a relative reference formula from one sheet to another. | Excel Discussion (Misc queries) | |||
| How do I copy a reference formula onto multiple worksheets | Excel Worksheet Functions | |||
| HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
Hybrid Mode
