Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 'Set Current Workbook as Master
- Set masterWB = Application.ThisWorkbook
- 'Set some Workbook as the one you are copying from
- Set dailyWB = Workbooks.Open(Sheets("Control Manager").Range("O2"))
- 'Copy the Range from dailyWB and Paste it into the MasterWB
- dailyWB.Sheets("Summary").Range("A1:BJ200").Copy masterWB.Sheets("AFS Summary").Range("A1").Rows("1:1")
- 'formatting and paste as values
- Workbooks("Workbook B").Activate
- Worksheets("Summary").Select
Add Comment
Please, Sign In to add comment