| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display 2 formulas from source workbooks to destination workbooks
In source workbook, value of cell 1 is 2*D5+45*C3. I also store 5+7*3*K7 in
cell 2. How can I display 2*D5+45*C3+5+7*3*K7 in cell 3 of destination workbook. I am running on Excel 2003. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display 2 formulas from source workbooks to destination workbooks
One way, Tools, Macro, Record New Macro and confirm the name you wish to use, Select the cell to copy and Copy, Select the sheet and cell to paste and Paste stop recording, (if you lose the stop, then Tools, Macro, Stop Recording) Then Tools, Macro, Macros, select the macro and Edit it should look like: Sub Macro2() ' ' Macro2 Macro ' Macro recorded 26/04/2006 by ' Range("A1").Select Selection.Copy Sheets("Sheet3").Select Range("A1").Select ActiveSheet.Paste - Range("A1").Value = " ' " & Range("A1").Formula- End Sub Just add the line shown in blue, and run the macro from the original sheet. This should help -- Excel_seek_help Wrote: In source workbook, value of cell 1 is 2*D5+45*C3. I also store 5+7*3*K7 in cell 2. How can I display 2*D5+45*C3+5+7*3*K7 in cell 3 of destination workbook. I am running on Excel 2003. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=536195 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display 2 formulas from source workbooks to destination workbo
Thx for your reply and I modified the macro as below to bring the values to
Sheet3: In Source workbook Sheet 1 Cell A1, I entered 2*D5+45*C3 In Source workbook Sheet 1 Cell B1, I entered 5+7*3*K7 Sub Macro2() ' ' Macro2 Macro ' Macro recorded 04-26-2006 by Range("a1:a2").Select Selection.Copy Sheets("Sheet3").Select Range("A1:a2").Select ActiveSheet.Paste Range("A1:a2").Value = "'" & Range("A1:a2").Formula End Sub Only Source workbook Sheet 1 Cell A1, I entered 2*D5+45*C3 copied to Sheet3 A1. Source workbook Sheet 1 Cell B1, I entered 5+7*3*K7 did not copy to Sheet3 B2 as expected. Furthermore, what will be the next step to show Cell A1 as 2*D5+45*C3+5+7*3*K7 in the Sheet3 or in NEW destination workbook. Appreciate your reply in advance. "Bryan Hessey" wrote: One way, Tools, Macro, Record New Macro and confirm the name you wish to use, Select the cell to copy and Copy, Select the sheet and cell to paste and Paste stop recording, (if you lose the stop, then Tools, Macro, Stop Recording) Then Tools, Macro, Macros, select the macro and Edit it should look like: Sub Macro2() ' ' Macro2 Macro ' Macro recorded 26/04/2006 by ' Range("A1").Select Selection.Copy Sheets("Sheet3").Select Range("A1").Select ActiveSheet.Paste - Range("A1").Value = " ' " & Range("A1").Formula- End Sub Just add the line shown in blue, and run the macro from the original sheet. This should help -- Excel_seek_help Wrote: In source workbook, value of cell 1 is 2*D5+45*C3. I also store 5+7*3*K7 in cell 2. How can I display 2*D5+45*C3+5+7*3*K7 in cell 3 of destination workbook. I am running on Excel 2003. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=536195 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display 2 formulas from source workbooks to destination workbooks
Range("A1:a2").Value = "'" & Range("A1:a2").Formula is invalid, Sheets("Sheet3").Range("A1").Value = " ' " & Sheets("Sheet1").Range("A1").Formula & "+" & Sheets("Sheet1").Range("B1").Formula should work -- Excel_seek_help Wrote: Thx for your reply and I modified the macro as below to bring the values to Sheet3: In Source workbook Sheet 1 Cell A1, I entered 2*D5+45*C3 In Source workbook Sheet 1 Cell B1, I entered 5+7*3*K7 Sub Macro2() ' ' Macro2 Macro ' Macro recorded 04-26-2006 by Range("a1:a2").Select Selection.Copy Sheets("Sheet3").Select Range("A1:a2").Select ActiveSheet.Paste Range("A1:a2").Value = "'" & Range("A1:a2").Formula End Sub Only Source workbook Sheet 1 Cell A1, I entered 2*D5+45*C3 copied to Sheet3 A1. Source workbook Sheet 1 Cell B1, I entered 5+7*3*K7 did not copy to Sheet3 B2 as expected. Furthermore, what will be the next step to show Cell A1 as 2*D5+45*C3+5+7*3*K7 in the Sheet3 or in NEW destination workbook. Appreciate your reply in advance. "Bryan Hessey" wrote: One way, Tools, Macro, Record New Macro and confirm the name you wish to use, Select the cell to copy and Copy, Select the sheet and cell to paste and Paste stop recording, (if you lose the stop, then Tools, Macro, Stop Recording) Then Tools, Macro, Macros, select the macro and Edit it should look like: Sub Macro2() ' ' Macro2 Macro ' Macro recorded 26/04/2006 by ' Range("A1").Select Selection.Copy Sheets("Sheet3").Select Range("A1").Select ActiveSheet.Paste - Range("A1").Value = " ' " & Range("A1").Formula- End Sub Just add the line shown in blue, and run the macro from the original sheet. This should help -- Excel_seek_help Wrote: In source workbook, value of cell 1 is 2*D5+45*C3. I also store 5+7*3*K7 in cell 2. How can I display 2*D5+45*C3+5+7*3*K7 in cell 3 of destination workbook. I am running on Excel 2003. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=536195 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=536195 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display 2 formulas from source workbooks to destination workbo
Thx. It works.
"Bryan Hessey" wrote: Range("A1:a2").Value = "'" & Range("A1:a2").Formula is invalid, Sheets("Sheet3").Range("A1").Value = " ' " & Sheets("Sheet1").Range("A1").Formula & "+" & Sheets("Sheet1").Range("B1").Formula should work -- Excel_seek_help Wrote: Thx for your reply and I modified the macro as below to bring the values to Sheet3: In Source workbook Sheet 1 Cell A1, I entered 2*D5+45*C3 In Source workbook Sheet 1 Cell B1, I entered 5+7*3*K7 Sub Macro2() ' ' Macro2 Macro ' Macro recorded 04-26-2006 by Range("a1:a2").Select Selection.Copy Sheets("Sheet3").Select Range("A1:a2").Select ActiveSheet.Paste Range("A1:a2").Value = "'" & Range("A1:a2").Formula End Sub Only Source workbook Sheet 1 Cell A1, I entered 2*D5+45*C3 copied to Sheet3 A1. Source workbook Sheet 1 Cell B1, I entered 5+7*3*K7 did not copy to Sheet3 B2 as expected. Furthermore, what will be the next step to show Cell A1 as 2*D5+45*C3+5+7*3*K7 in the Sheet3 or in NEW destination workbook. Appreciate your reply in advance. "Bryan Hessey" wrote: One way, Tools, Macro, Record New Macro and confirm the name you wish to use, Select the cell to copy and Copy, Select the sheet and cell to paste and Paste stop recording, (if you lose the stop, then Tools, Macro, Stop Recording) Then Tools, Macro, Macros, select the macro and Edit it should look like: Sub Macro2() ' ' Macro2 Macro ' Macro recorded 26/04/2006 by ' Range("A1").Select Selection.Copy Sheets("Sheet3").Select Range("A1").Select ActiveSheet.Paste - Range("A1").Value = " ' " & Range("A1").Formula- End Sub Just add the line shown in blue, and run the macro from the original sheet. This should help -- Excel_seek_help Wrote: In source workbook, value of cell 1 is 2*D5+45*C3. I also store 5+7*3*K7 in cell 2. How can I display 2*D5+45*C3+5+7*3*K7 in cell 3 of destination workbook. I am running on Excel 2003. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=536195 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=536195 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| XL2003 Destination and Source Open but not updating | Excel Discussion (Misc queries) | |||
| Automatic update of links in destination file when source file mo. | Excel Discussion (Misc queries) | |||
| Formulas in source data | Charts and Charting in Excel | |||
| Hyperlinks - identifying source in destination sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
