Copy data from mutiple workbooks and paste below each other

Closed
Fay - Nov 17, 2014 at 09:29 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Nov 22, 2014 at 06:33 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Nov 22, 2014 at 06:33 AM
copy to same sheet or copy to different sheets ?
0