وعليكم السلام ورحمة الله تعالى وبركاته
تفضل اخي
Option Explicit
Sub Transfer()
Dim wbData As Workbook, wsData As Worksheet
Dim rngToCopy As Range, cl As Range
Dim C As Long, LastRow As Long
Dim wsMain As Worksheet: Set wsMain = ThisWorkbook.ActiveSheet
Application.ScreenUpdating = False
Set wbData = Workbooks.Open("C:\Users\Ehab Elhady\Desktop\1.xlsx")
Set wsData = wbData.Sheets("Sheet1")
Set rngToCopy = wsMain.Range("D6,D8,D10,D12,D14,G6,G8,G10,G12,G14")
LastRow = wsData.Cells(wsData.Rows.Count, "A").End(xlUp).Row
C = 1
For Each cl In rngToCopy
cl.Copy
wsData.Cells(LastRow + 1, C).PasteSpecial xlPasteValues
C = C + 1
Next cl
wbData.Close True
Application.CutCopyMode = False
MsgBox " تم ترحيل البيانات بنجاح", vbInformation, "تعليمات"
End Sub
e_V2.rar