I am trying to copy specific cell data from one weekly report into a different formatted Master report. my goal is to be working in the Master sheet, select the macro which will open the weekly sheet in the background and copy and paste the specific cell data into their cells in the Master workbook. so far i have:
Sub check()
Dim weekly As Workbook
Dim twb As Workbook
Dim lrt As Long
Dim lrp As Long
Dim i As Long
Dim file As String
Dim efn1 As String
Dim efnr2 As Long
Dim li As String
Dim li2 As String
Dim dn As String
Dim msg As String
Dim dut As Double
file = Application.GetOpenFilename
Application.ScreenUpdating = False
If file <> "False" Then
Set weekly = Workbooks.Open(file)
Else
GoTo ee
End If
this gets the weekly file open but i dont know how to proceed to copy specifc data from the weekly sheet into the next available row on the Master. Any help would be appreciated
ee:
End Sub
Sub check()
Dim weekly As Workbook
Dim twb As Workbook
Dim lrt As Long
Dim lrp As Long
Dim i As Long
Dim file As String
Dim efn1 As String
Dim efnr2 As Long
Dim li As String
Dim li2 As String
Dim dn As String
Dim msg As String
Dim dut As Double
file = Application.GetOpenFilename
Application.ScreenUpdating = False
If file <> "False" Then
Set weekly = Workbooks.Open(file)
Else
GoTo ee
End If
this gets the weekly file open but i dont know how to proceed to copy specifc data from the weekly sheet into the next available row on the Master. Any help would be appreciated
ee:
End Sub