Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formula from one workbook to another without reference to 1st
I'm trying to copy formulas from one workbook to another with links to the
same worksheets that are in both workbooks, but when i copy and paste, or copy and paste special, it links the 2nd workbook back to the 1st workbook with the formula as follows: ='[1200-07.xls]Operating'!AE66 I would like it to appear as follows: ='Operating'!AE66 Any suggestions would greatly be appreciated. Thanks in advance for your help. -- Scott |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formula from one workbook to another without reference to 1st
Hi Scott,
Highlight the the formula when it's in the formula bar at the top of the sheet then press ctrl -C them move it and paste it. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "Scott" wrote: I'm trying to copy formulas from one workbook to another with links to the same worksheets that are in both workbooks, but when i copy and paste, or copy and paste special, it links the 2nd workbook back to the 1st workbook with the formula as follows: ='[1200-07.xls]Operating'!AE66 I would like it to appear as follows: ='Operating'!AE66 Any suggestions would greatly be appreciated. Thanks in advance for your help. -- Scott |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formula from one workbook to another without reference to 1st
After the copy/paste.
Assuming destination workbook has been saved. EditLinksChange Source.......select current workbook and OK The [1200.xls] will be gone leaving = 'Operating'!AE66 Gord Dibben MS Excel MVP On Fri, 12 Dec 2008 12:35:01 -0800, Scott wrote: I'm trying to copy formulas from one workbook to another with links to the same worksheets that are in both workbooks, but when i copy and paste, or copy and paste special, it links the 2nd workbook back to the 1st workbook with the formula as follows: ='[1200-07.xls]Operating'!AE66 I would like it to appear as follows: ='Operating'!AE66 Any suggestions would greatly be appreciated. Thanks in advance for your help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formula from one workbook to another without reference to
Same problem, your solution saved me from manually fixing 42000 cells. THANK
YOU! "Gord Dibben" wrote: After the copy/paste. Assuming destination workbook has been saved. EditLinksChange Source.......select current workbook and OK The [1200.xls] will be gone leaving = 'Operating'!AE66 Gord Dibben MS Excel MVP On Fri, 12 Dec 2008 12:35:01 -0800, Scott wrote: I'm trying to copy formulas from one workbook to another with links to the same worksheets that are in both workbooks, but when i copy and paste, or copy and paste special, it links the 2nd workbook back to the 1st workbook with the formula as follows: ='[1200-07.xls]Operating'!AE66 I would like it to appear as follows: ='Operating'!AE66 Any suggestions would greatly be appreciated. Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet to 2nd workbook but have no reference to 1st workbo | Excel Discussion (Misc queries) | |||
copy same formula with with different worksheet reference | Excel Discussion (Misc queries) | |||
copy formula to new workbook without [REFERENCE] | Excel Discussion (Misc queries) | |||
workbook/cell reference w/ formula | Excel Worksheet Functions | |||
HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) |