I came across below code
'transfer stuff from this workbook to workbook 2
Dim strPath2 As String
Dim wbkWorkbook1 As Workbook
Dim wbkWorkbook2 As Workbook
'define paths and filenames
strPath2 = "D:\Master.xlsx"
Set wbkWorkbook1 = ThisWorkbook
Set wbkWorkbook2 = Workbooks.Open(strPath2)
wbkWorkbook2.Worksheets("Sheet1").Range("A1:B3").Value = _
'close the workbook
What the code does is open up the master workbook, paste the data in one particular range and close the master workbook.
I'm looking for few additions to the above code, which I have mentioned above under - what the macro should do.
Any assistance will be greatly appreciated.