I have a procedure where from a workbook I select and open another
workbook and copy data values from that book (source) to the other
workbook ( target). Part of the procedure is shown below,



With targetfileEntries
.Range("A17:B161").Value = sourcefileEntries.Range("A12:B156").Value
.Range("D17:D161").Value = sourcefileEntries.Range("F12:F156").Value
.Range("E17:E161").Value =
sourcefileEntries.Range("E12:E156").Value
End With

What I would like to do is have a column in the target file i.e
Range("H17:H161").Value and I want it to be have the sum of the values
from the two columns

sourcefileEntries.Range("G12:H156").Value so that in the target file
for eaxmple Cell H17 has the value of the two cells in the source file
G12 plus H12.

I hope this is understandable as I wouls be most grateful for any help
and advice.



Kind Regards,



Graham
January 6, 2012 Reply with quote Report abuse
Child exploitation or abuseHarassment or threatsInappropriate/Adult
contentNudityProfanitySoftware piracySPAM/AdvertisingVirus/Spyware/
Malware dangerOther Term of Use or Code of Conduct violation 1 Person
had
this question Stop emails Graham62