| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying a Column of Formulas between Excel Files
I'd like to be able to copy a column of hyperlink formjula cells, e.g.,
=HYPERLINK('P1'!$B$49,'P1'!$A$49), from one Excel file to another, leaving the formulas as they are in the original file. The default seems to be for Excel to cleverly add a reference to the original file into the formula, =HYPERLINK('[PIID Worksheet-projects1.xls]P1'!$B$49,'[PIID Worksheet-projects1.xls]P1'!$A$49) But how can I get an exact copy of my column of formulas from one file to another? Thanks, Bill |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a Column of Formulas between Excel Files
When pasting to the target file use the Paste Special option selecting
Fromulas only, and if you also need the formatting do that as a second step. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "WillW" wrote: I'd like to be able to copy a column of hyperlink formjula cells, e.g., =HYPERLINK('P1'!$B$49,'P1'!$A$49), from one Excel file to another, leaving the formulas as they are in the original file. The default seems to be for Excel to cleverly add a reference to the original file into the formula, =HYPERLINK('[PIID Worksheet-projects1.xls]P1'!$B$49,'[PIID Worksheet-projects1.xls]P1'!$A$49) But how can I get an exact copy of my column of formulas from one file to another? Thanks, Bill |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a Column of Formulas between Excel Files
Did you try that?
-- Regards, Peo Sjoblom "Michael" wrote in message ... When pasting to the target file use the Paste Special option selecting Fromulas only, and if you also need the formatting do that as a second step. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "WillW" wrote: I'd like to be able to copy a column of hyperlink formjula cells, e.g., =HYPERLINK('P1'!$B$49,'P1'!$A$49), from one Excel file to another, leaving the formulas as they are in the original file. The default seems to be for Excel to cleverly add a reference to the original file into the formula, =HYPERLINK('[PIID Worksheet-projects1.xls]P1'!$B$49,'[PIID Worksheet-projects1.xls]P1'!$A$49) But how can I get an exact copy of my column of formulas from one file to another? Thanks, Bill |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a Column of Formulas between Excel Files
Try this, in the workbook with the original hyperlink formulas do
editreplace (or ctrl +h) find what = replace with ^=^ so replace the equals sign with a dummy text string not likely to be in any of the formulas select the replaced formulas which are now regular text strings, copy and paste them into the new workbook. Finally reverse it find what ^=^ replace with = in both workbooks -- Regards, Peo Sjoblom "WillW" wrote in message ... I'd like to be able to copy a column of hyperlink formjula cells, e.g., =HYPERLINK('P1'!$B$49,'P1'!$A$49), from one Excel file to another, leaving the formulas as they are in the original file. The default seems to be for Excel to cleverly add a reference to the original file into the formula, =HYPERLINK('[PIID Worksheet-projects1.xls]P1'!$B$49,'[PIID Worksheet-projects1.xls]P1'!$A$49) But how can I get an exact copy of my column of formulas from one file to another? Thanks, Bill |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a Column of Formulas between Excel Files
Thanks, Michael -- this was the first thing I tried. But it does not prevent
the file name from being added to the formulas when I paste the column into the second file. "Michael" wrote: When pasting to the target file use the Paste Special option selecting Fromulas only, and if you also need the formatting do that as a second step. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "WillW" wrote: I'd like to be able to copy a column of hyperlink formjula cells, e.g., =HYPERLINK('P1'!$B$49,'P1'!$A$49), from one Excel file to another, leaving the formulas as they are in the original file. The default seems to be for Excel to cleverly add a reference to the original file into the formula, =HYPERLINK('[PIID Worksheet-projects1.xls]P1'!$B$49,'[PIID Worksheet-projects1.xls]P1'!$A$49) But how can I get an exact copy of my column of formulas from one file to another? Thanks, Bill |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a Column of Formulas between Excel Files
Thanks very much. This works.
I often wished for a new option on Paste Special: Exact, i.e., formulas - or whatever - would be pasted exactly as they exist in the original cell. In many cases, this could eliminate the use of $ and would certainly help in my current situation. "Peo Sjoblom" wrote: Try this, in the workbook with the original hyperlink formulas do editreplace (or ctrl +h) find what = replace with ^=^ so replace the equals sign with a dummy text string not likely to be in any of the formulas select the replaced formulas which are now regular text strings, copy and paste them into the new workbook. Finally reverse it find what ^=^ replace with = in both workbooks -- Regards, Peo Sjoblom "WillW" wrote in message ... I'd like to be able to copy a column of hyperlink formjula cells, e.g., =HYPERLINK('P1'!$B$49,'P1'!$A$49), from one Excel file to another, leaving the formulas as they are in the original file. The default seems to be for Excel to cleverly add a reference to the original file into the formula, =HYPERLINK('[PIID Worksheet-projects1.xls]P1'!$B$49,'[PIID Worksheet-projects1.xls]P1'!$A$49) But how can I get an exact copy of my column of formulas from one file to another? Thanks, Bill |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a Column of Formulas between Excel Files
I agree
-- Regards, Peo Sjoblom "WillW" wrote in message ... Thanks very much. This works. I often wished for a new option on Paste Special: Exact, i.e., formulas - or whatever - would be pasted exactly as they exist in the original cell. In many cases, this could eliminate the use of $ and would certainly help in my current situation. "Peo Sjoblom" wrote: Try this, in the workbook with the original hyperlink formulas do editreplace (or ctrl +h) find what = replace with ^=^ so replace the equals sign with a dummy text string not likely to be in any of the formulas select the replaced formulas which are now regular text strings, copy and paste them into the new workbook. Finally reverse it find what ^=^ replace with = in both workbooks -- Regards, Peo Sjoblom "WillW" wrote in message ... I'd like to be able to copy a column of hyperlink formjula cells, e.g., =HYPERLINK('P1'!$B$49,'P1'!$A$49), from one Excel file to another, leaving the formulas as they are in the original file. The default seems to be for Excel to cleverly add a reference to the original file into the formula, =HYPERLINK('[PIID Worksheet-projects1.xls]P1'!$B$49,'[PIID Worksheet-projects1.xls]P1'!$A$49) But how can I get an exact copy of my column of formulas from one file to another? Thanks, Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying a column of cells containing formulas without them changin | Excel Discussion (Misc queries) | |||
| Copying formulas to end of Column | Excel Discussion (Misc queries) | |||
| Copying Formulas From One Column To Another?? | Excel Worksheet Functions | |||
| Excel keeps copying deleted files | Excel Discussion (Misc queries) | |||
| Copying Formulas in LARGE Files | Excel Worksheet Functions | |||
Linear Mode
