Display 2 formulas from source workbooks to destination workbooks

E

Excel_seek_help

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.
 
B

Bryan Hessey

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

--
 
E

Excel_seek_help

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.
 
B

Bryan Hessey

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 said:
Thx for your reply and I modified the macro as below to bring the value
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 t
Sheet3
A1. Source workbook Sheet 1 Cell B1, I entered 5+7*3*K7 did not cop
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.
Click to expand...
 
E

Excel_seek_help

Thx. It works.

Bryan Hessey said:
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
Click to expand...
 
Top