Thanks again Mr. Stan
Simply I need to copy temp sheets (both of them) number of times according to the range Q2:Q9
I attached two copied sheets for first instance (Q2) COM 1A & COM 1B and show you how the results should be ..
Finally I should have 16 sheets (based on the two temp sheets) 8 sheets for TempA and 8 sheets for TempB
and for every sheet of the 16 specific range to be copied according to columns R:S which have the start row and end row for each range to copy
Bookmarks