Copying blocks of rows into new worksheets

**eonizuka** · 07-01-2009, 02:36 PM

What I'd like to do is to have the block of rows starting from "Agent:" and ending with "Total" copied into a separate worksheet and then have the worksheet named using the agent's name. I have highlighted the data in yellow in the attached reference file. I would like to have this done for all 58 agents. I could copy and paste manually but that wouldn't be the smartest way to go about this. I figure I probably need a looping structure for this but I am not yet proficient enough to figure this out quickly. I am supposed to have this done today... Thanks in advance to anyone willing to assist.

Edit: The last part of this would be to have blocks of rows from the "sections" worksheet which use identical agent names also pasted below the data from the "questions" worksheet. I have attached the workbook I am working on now cutting and pasting manually. I would greatly appreciate it if someone would be willing to write out some code for this so I can use it in the future as well as to learn from it. Thanks again.

**JBeaucaire** · 07-01-2009, 03:45 PM

Give this a try:

Please Login or Register  to view this content.

**eonizuka** · 07-01-2009, 03:49 PM

Apologies for the edit including additional requirements; I know that must be a little annoying. Thanks so much for your help Jbeaucaire.

**JBeaucaire** · 07-01-2009, 04:00 PM

Round two:

Please Login or Register  to view this content.

**eonizuka** · 07-01-2009, 04:09 PM

I apologize for the annoyance and am sure you have heard this many times before, but thank you very much for your willingness to openly share your knowledge and time. I think I was on the 20th worksheet by the time you finished your code that completed the entire task in a matter of seconds. I gotta get these looping structures down...