Sub CarryOverData()
Dim FName As String
Dim wkBook As Workbook
With Application
.ScreenUpdating = False
FName = .GetOpenFilename
End With
If FName <> "False" Then
Set wkBook = Workbooks.Open( _
Filename:=FName)
With wkBook
.Worksheets("Sheet1").Range("A:Z").Copy _
Destination:=ThisWorkbook.Worksheets("Sheet1").Range("A:Z")
.Close _
SaveChanges:=False
End With
End If
With Application
.CutCopyMode = False
.ScreenUpdating = True
End With
End Sub
Bookmarks