asked on Excel Macro - Copy / Paste Sheets from one workbook to another
Hello Experts,
I'm sure this is very simple, but need your expertise to do that macro. I need to copy data from workbookA.SheetIN_Data and paste it into workbookB.SheetIN_Data, starting at cell A2 (Row 1 are my headers in workbookB).
I have a total of 6 sheets that need the data to be transfert from one book to the other (SheetIN_Data,SheetCH_Data
Can you help?
I'm sure this is very simple, but need your expertise to do that macro. I need to copy data from workbookA.SheetIN_Data and paste it into workbookB.SheetIN_Data, starting at cell A2 (Row 1 are my headers in workbookB).
I have a total of 6 sheets that need the data to be transfert from one book to the other (SheetIN_Data,SheetCH_Data
Can you help?
Microsoft Excel
Last Comment
Martin Liss
Sub CopySheetData()
Dim wbDest As Workbook
Dim wbSource As Workbook
Set wbSource = ActiveWorkbook
Set wbDest = Workbooks("workbookB")
wbSource.Sheets("SheetIN_Data").UsedRange.Cells.Offset(1, 0).Copy Destination:=wbDest.Sheets("SheetIN_Data").Range("A2")
End Sub
Is the data from all sheets being consloidated into one sheet in the other workbook?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi Martin,
This work just fine!!
thanks,
xxx
/mld
This work just fine!!
thanks,
xxx
/mld
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
gowflow