Copy data from mutiple workbooks and paste below each other [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I need to copy data from multiple workbooks and paste in another workbook below each other.

This is the first part. I need to copy data from another workbook and paste it below the data I've already copied from the first workbook:


Sub Consolidate()

coVersion = Application.Sheets("Variables").Range("B2").Value
fmVersion = Application.Sheets("Variables").Range("B3").Value

coV = coVersion & ".xlsm"
fmV = fmVersion & ".xlsm"

Workbooks(fmV).Worksheets("FM Export").UsedRange.Copy
Workbooks(coV).Worksheets("Consolidated").Range("A1").PasteSpecial (xlPasteValues)
Workbooks(coV).Worksheets("Consolidated").Range("A1").PasteSpecial (xlPasteFormats)
Application.CutCopyMode = False


Application.ScreenUpdating = True

End Sub

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
762
copy to same sheet or copy to different sheets ?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!