Hi All,
I have a worksheet (a basic sample I have attached) that I've been asked to make a dynamic sorting library so to speak.
I've been trying to use Data Validation or Pivot tables but it isn't getting the result I want.
I'm aiming to basically have an overall table as my database, and then on the "sorting library" page, have various categories people can choose (preferably in the form of a drop down list on the left hand side) and on the right hand side have results displayed which matches the category chosen.
So, if having 5 different drop down lists people can choose their preference for each one and end up with a final sorted list from the database which would suit their needs.
A slicer is okay but the request from the office is a drop down box due to aesthetic looks and ease of use by many people and the wish for the sorted table not to be seen until a category is chosen, unlike a pivot table where all values are seen until you chosen all filters (also how you cannot move the dropdown box to be next to the table itself).
Please help as I am really stuck!!!!!
If more explanation is needed then please ask, but any direction or help would be greatly appreciated
Bookmarks