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.

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

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

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

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