The below is a macro that opens a workbook, it copies an active sheet, opens a workbook (wb Target) and then pastes to the workbook that was just opened.

I have a few active sheets i would like to copy and paste

As the opened workbook (wb Target) wasnt closed, how would i get it to just copy and paste without reopening to same workbook?


ActiveSheet.Range("b2:u44").Copy
 Set wbTarget = Workbooks.Open("P:\Customer Contact Managers\MI_Resource_planning\A OUR TEMPLATES\People Daily.1.xlsx")
Below is the next step

Cells(3, Columns.Count).End(xlToLeft).Offset(, 6).PasteSpecial xlPasteAll