Hi All,

I need a maco that would look down column b and at each change of data copy
the previous rows to a new sheet.

John books
John books
Kate puzzles
Kate puzzles

The macro would copy the first two rows to a new sheet and then the next tow
rows to a new sheet ect.

Any help would be greatly appreciated.