Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
How to set multiple filter values for a filter in the page fields | Excel Programming |