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