Hi Guys
I have a a few string stored in column A of a excel workbook "Book1"
I want VBA to pick up the names and copy the same named sheets that i have in another excel "Book2" and paste it to book1
Set ListC = Range("C2:C100")
Windows("Book2").Activate
For Each c In ListC
Sheets(c).Copy After:=Workbooks("Book1.xlsm").Sheets(Workbooks("Book1.xlsm").Sheets.Count)
Next c
End Sub
I have a a few string stored in column A of a excel workbook "Book1"
I want VBA to pick up the names and copy the same named sheets that i have in another excel "Book2" and paste it to book1
Set ListC = Range("C2:C100")
Windows("Book2").Activate
For Each c In ListC
Sheets(c).Copy After:=Workbooks("Book1.xlsm").Sheets(Workbooks("Book1.xlsm").Sheets.Count)
Next c
End Sub