View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wouter HM Wouter HM is offline
external usenet poster
 
Posts: 99
Default 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