I have an excel file where i need to be able to enter or select a value from a dropdown menu but when selected the value is then used in another sheet to automatically apply a filter to that data, So user selects value clicks a button and the filter works on another sheet.
Can't get my head around how to do this one!
Bookmarks