Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy a formula to another sheet
Hi
I have a sheet where some of the columns are calculated as a combination of data in other columns. I use formulas to do it. When I want to copy any formula within the sheet it is easy using Spacial Paste. I have also other sheets in the same or in other files which are very similar but I don't know how to copy my formulas there. Could anyone help me? I'd be very grateful. Regards E |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy a formula to another sheet
What happens if you just open the other workbook and edit|copy and
edit|pastespecial values (or formulas). If your formulas still point to worksheets in the original workbook, you may be able to copy from the formula bar and paste into the formula bar. E wrote: Hi I have a sheet where some of the columns are calculated as a combination of data in other columns. I use formulas to do it. When I want to copy any formula within the sheet it is easy using Spacial Paste. I have also other sheets in the same or in other files which are very similar but I don't know how to copy my formulas there. Could anyone help me? I'd be very grateful. Regards E -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy a formula to another sheet
Thanks for your answer.
When I copy a formula within the same sheet I select it, then I use "Copy" and then I use"Paste Special" where I can select "Formula" in the same way as I can select "Value" to copy just value. When I try to do the same copying a formula to another workbook I get a different kind of window which contains things like Object, Format, Bitmap etc.but no "Formula" to choose. I have never used something like formulas which point to another sheet or workbook. I simply want to copy formulas and use the sheets separately. However if it was the only way to solve my problem I could consider it, but at the moment I don't know how to do it. What happens if you just open the other workbook and edit|copy and edit|pastespecial values (or formulas). If your formulas still point to worksheets in the original workbook, you may be able to copy from the formula bar and paste into the formula bar. I have a sheet where some of the columns are calculated as a combination of data in other columns. I use formulas to do it. When I want to copy any formula within the sheet it is easy using Spacial Paste. I have also other sheets in the same or in other files which are very similar but I don't know how to copy my formulas there. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy a formula to another sheet
You have two different instances of excel open.
Close one of them and then use File|open (or its xl2007 equivalent) to open the other workbook. Then try your copy|paste. E wrote: Thanks for your answer. When I copy a formula within the same sheet I select it, then I use "Copy" and then I use"Paste Special" where I can select "Formula" in the same way as I can select "Value" to copy just value. When I try to do the same copying a formula to another workbook I get a different kind of window which contains things like Object, Format, Bitmap etc.but no "Formula" to choose. I have never used something like formulas which point to another sheet or workbook. I simply want to copy formulas and use the sheets separately. However if it was the only way to solve my problem I could consider it, but at the moment I don't know how to do it. What happens if you just open the other workbook and edit|copy and edit|pastespecial values (or formulas). If your formulas still point to worksheets in the original workbook, you may be able to copy from the formula bar and paste into the formula bar. I have a sheet where some of the columns are calculated as a combination of data in other columns. I use formulas to do it. When I want to copy any formula within the sheet it is easy using Spacial Paste. I have also other sheets in the same or in other files which are very similar but I don't know how to copy my formulas there. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy a formula to another sheet
I tried to do it according to your advice but after opening the second file
(the one where I want to paste the formula to) I get a windows with: Text Unicode Text and nothing more. You have two different instances of excel open. Close one of them and then use File|open (or its xl2007 equivalent) to open the other workbook. Then try your copy|paste. When I copy a formula within the same sheet I select it, then I use "Copy" and then I use"Paste Special" where I can select "Formula" in the same way as I can select "Value" to copy just value. When I try to do the same copying a formula to another workbook I get a different kind of window which contains things like Object, Format, Bitmap etc.but no "Formula" to choose. I have never used something like formulas which point to another sheet or workbook. I simply want to copy formulas and use the sheets separately. However if it was the only way to solve my problem I could consider it, but at the moment I don't know how to do it. What happens if you just open the other workbook and edit|copy and edit|pastespecial values (or formulas). If your formulas still point to worksheets in the original workbook, you may be able to copy from the formula bar and paste into the formula bar. I have a sheet where some of the columns are calculated as a combination of data in other columns. I use formulas to do it. When I want to copy any formula within the sheet it is easy using Spacial Paste. I have also other sheets in the same or in other files which are very similar but I don't know how to copy my formulas there. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy a formula to another sheet
I solved the problem partially. I was wrong thinking that it doesn't work
when I copy a formula to onother sheet in the same workbook. It is OK within the same sheet and within the same workbook. So I can copy the second file as an another sheet to the workbook with the first sheet and copy formulas. Then I have to copy the second sheet to a new workbook. It is necessary because I have to use MailMerge afterwords. I tried to do it according to your advice but after opening the second file (the one where I want to paste the formula to) I get a windows with: Text Unicode Text and nothing more. You have two different instances of excel open. Close one of them and then use File|open (or its xl2007 equivalent) to open the other workbook. Then try your copy|paste. When I copy a formula within the same sheet I select it, then I use "Copy" and then I use"Paste Special" where I can select "Formula" in the same way as I can select "Value" to copy just value. When I try to do the same copying a formula to another workbook I get a different kind of window which contains things like Object, Format, Bitmap etc.but no "Formula" to choose. I have never used something like formulas which point to another sheet or workbook. I simply want to copy formulas and use the sheets separately. However if it was the only way to solve my problem I could consider it, but at the moment I don't know how to do it. What happens if you just open the other workbook and edit|copy and edit|pastespecial values (or formulas). If your formulas still point to worksheets in the original workbook, you may be able to copy from the formula bar and paste into the formula bar. I have a sheet where some of the columns are calculated as a combination of data in other columns. I use formulas to do it. When I want to copy any formula within the sheet it is easy using Spacial Paste. I have also other sheets in the same or in other files which are very similar but I don't know how to copy my formulas there. Regards E |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy a formula to another sheet
You still have two instances of excel running.
Close all the running instances of excel (just to start from a clean slate). Then open excel. File|open the first workbook. File|open the second workbook. (Using file|open will insure that you only have one instance of excel running.) Try the copy|paste. E wrote: I tried to do it according to your advice but after opening the second file (the one where I want to paste the formula to) I get a windows with: Text Unicode Text and nothing more. You have two different instances of excel open. Close one of them and then use File|open (or its xl2007 equivalent) to open the other workbook. Then try your copy|paste. When I copy a formula within the same sheet I select it, then I use "Copy" and then I use"Paste Special" where I can select "Formula" in the same way as I can select "Value" to copy just value. When I try to do the same copying a formula to another workbook I get a different kind of window which contains things like Object, Format, Bitmap etc.but no "Formula" to choose. I have never used something like formulas which point to another sheet or workbook. I simply want to copy formulas and use the sheets separately. However if it was the only way to solve my problem I could consider it, but at the moment I don't know how to do it. What happens if you just open the other workbook and edit|copy and edit|pastespecial values (or formulas). If your formulas still point to worksheets in the original workbook, you may be able to copy from the formula bar and paste into the formula bar. I have a sheet where some of the columns are calculated as a combination of data in other columns. I use formulas to do it. When I want to copy any formula within the sheet it is easy using Spacial Paste. I have also other sheets in the same or in other files which are very similar but I don't know how to copy my formulas there. -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy a formula to another sheet
Thank you very much. It works. :-)
Regards E You still have two instances of excel running. Close all the running instances of excel (just to start from a clean slate). Then open excel. File|open the first workbook. File|open the second workbook. (Using file|open will insure that you only have one instance of excel running.) Try the copy|paste. I tried to do it according to your advice but after opening the second file (the one where I want to paste the formula to) I get a windows with: Text Unicode Text and nothing more. You have two different instances of excel open. Close one of them and then use File|open (or its xl2007 equivalent) to open the other workbook. Then try your copy|paste. When I copy a formula within the same sheet I select it, then I use "Copy" and then I use"Paste Special" where I can select "Formula" in the same way as I can select "Value" to copy just value. When I try to do the same copying a formula to another workbook I get a different kind of window which contains things like Object, Format, Bitmap etc.but no "Formula" to choose. I have never used something like formulas which point to another sheet or workbook. I simply want to copy formulas and use the sheets separately. However if it was the only way to solve my problem I could consider it, but at the moment I don't know how to do it. What happens if you just open the other workbook and edit|copy and edit|pastespecial values (or formulas). If your formulas still point to worksheets in the original workbook, you may be able to copy from the formula bar and paste into the formula bar. I have a sheet where some of the columns are calculated as a combination of data in other columns. I use formulas to do it. When I want to copy any formula within the sheet it is easy using Spacial Paste. I have also other sheets in the same or in other files which are very similar but I don't know how to copy my formulas there. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
copy formula referencing sheet name to another sheet | Excel Worksheet Functions | |||
Copy formula...sheet 2 sheet | New Users to Excel |