Updating another workbook
On 5 mei, 14:24, WLMPilot wrote:
I would like to know how to take data in cell A1 of Workbook1.Sheet1 and
place it in cell A1 of Workbook2.Sheet2 via a macro from workbook1?
Thanks.
Hi,
Your question is very short.
Based on this information I can only give this example:
Sub Copy1Cell()
Workbooks("Workbook2").Worksheets("Sheet2").Range( "A1").Value = _
Workbooks("Workbook1").Worksheets("Sheet1").Range( "A1").Value
End Sub
HTH,
Wouter
|