Hi, On my complicated excel spreadsheet I have names of clients in column A
say starting from A5. Names of staff across horizontally starting in J4.
Below the names of people a tick symbol has been typed in to indicate who's
working on which client. There are gaps between groups of people. When I
click on Autofilter, it doesn't seem to recognise the date below. I do have
various subheadings above the staff names and merged cells. What I am trying
to achieve is when I select a staff from the filter it should show me all
clients that staff is responsible for but its not picking this up. Can
someone help?