Start here
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sean" wrote in message ...
I am new to macros in excel but need to create one I believe to get what I
want. My problem is I am given a spreadsheet that has one one sheet. The
one sheet has a class list of students for all the different classes we have
this week (more than 40) each class "roster" starts and ends with the same
cell first row starts with "Company Name" Last cell for that given class
roster ends with "Page 1 of 1"

What I would like is a macro that will separate each roster on to a new
sheet, the problem some rosters are 30 rows while others can be as many as 40
so I don't know how to have excel select a range of cells to copy and paste
to a new sheet by whats in the cells. I can't change how the initial sheet
is setup in any way.