D
dctalk
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?
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?