Hi all,

I have a workbook that lists service users by team, now each service user
can appear in more than one team.
Each team is seperated by 10 blank lines which is necessary.
I have a simple macro that will filter based on the service users name. But
the problem is that beause each team is seperated by the 10 blank lines. If I
go to the heading in the very first team and apply the filter it will only
filter for that person if the are in that team.
If I get rid of the blank lines its works fine, but I need those line to
remain blank.
Is there any way to get excel to treat all the teams as one whole block of
data?

Any help will be greatly appreciated.
--

_______________________
Naz,
London