help with macro to export data

  • Thread starter Thread starter Mayte
  • Start date Start date
M

Mayte

can I use a macro to export data to another workbook? I mean, if I have data
on workbook 1, Sheet A ... can I use a macro to export all data from
"Workbook 1, Sheet A" to "Workbook 2 Sheet B" ??

Thanks,
Mayte
 
Maybe you can use this macro:

Sub sheetcopy()
Workbooks("Workbook 1.xls").Sheets("Sheet A").Copy _
After:=Workbooks("Workbook 2.xls"). _
Sheets(Workbooks("Workbook 2.xls").Sheets.Count)
Workbooks("Workbook 2.xls"). _
Sheets(Workbooks("Workbook 2.xls").Sheets.Count).Name = "Sheet B"
End Sub

Regards,
Stefi


„Mayte†ezt írta:
 
great ...thanks a lot !!

Cheers,
Matyte

Stefi said:
Maybe you can use this macro:

Sub sheetcopy()
Workbooks("Workbook 1.xls").Sheets("Sheet A").Copy _
After:=Workbooks("Workbook 2.xls"). _
Sheets(Workbooks("Workbook 2.xls").Sheets.Count)
Workbooks("Workbook 2.xls"). _
Sheets(Workbooks("Workbook 2.xls").Sheets.Count).Name = "Sheet B"
End Sub

Regards,
Stefi


„Mayte†ezt írta:
Click to expand...
 
Back
Top