Hello,
Please see the attached workbook.
In Columns R:T i have a table with a filter in place.
There's a macro working which enables the filter to always be on in column R by hiding the N/A rows.
As you can see, I can choose to view what i wish with the filter. So under "Venue" I can select "Hall" and I'll be shown only the "Hall" rows...
Is it possible to be able to make these filter selections from C10:E10?
moving the original table is not an option im afraid
thank you
Bookmarks