help with macro to export data

[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

 

[Stefi]

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:

 

[Mayte]

great ...thanks a lot !!

Cheers,
Matyte

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: