Copy specific cell from one workbook into a new open row in another

odav

New Member
Joined
May 4, 2022
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
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
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,214,641
Messages
6,120,693
Members
448,979
Latest member
DET4492

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top