Hi:

I have a workbook that has rows of data starting at A5:G5 seperated in groups of 25 rows.
Example: A5 is numbered 1 and A6 is 2 A7 is 3 and so on to 25 then skip a row and start numbering again to 25.

What this is for is employees are placed in groups of 25 to be eligible for an award for safety.

What I want to do is Range G5:G650 is to be a place where an "X" is placed beside an employee who has had an accident then Range H5:H650 would return "Employee had an accident" I already have this part working.

Then I want to code a subroutine that would search for the "X's" and return the entire row data for each name in that group of 25 on a seperate worksheet.
This would then be printed so we would know which group's to exclude.

I know how to make it return the row of data containing the "X" but how can I make it grab the entire group?

There will be multiple groups of 25 each and each time an "X" is found within a group create a new worksheet for that group.

650 employees / 25 = 26 groups

Can it be done?

Thanks
Charles