Hi there,
First time here and first post - thanks for reading and helping!
I'm trying to create a spreadsheet to help with a friend's Event Planning business.
The idea is that there is a table which is the master database of suppliers. These can be categorized and sub categorized through drop-down lists. I've done this mainly using the =INDIRECT("x") function in Data Validation and seems OK.
Now the challenge:
I'm looking to make another table to select only a few of suppliers for a given event from the Master List, navigating & then filtering by sub-category.
If we can get this working, I'd want the selected suppliers details to automatically fill in to the selected supplier area.
Attached is an example spreadsheet, partially working.
The idea is that you'd make a selection in cell P2, eg.DJ. Cell Q2 would then have a second drop-down showing all the suppliers with 'DJ' as their sub-category in the Master Supplier List.
The coloured area is the part I'm really struggling with.
I've watched a load of tutorials and not really sure how to progress.
Any advice would be great!
Thanks, Mic
edit
Adding image for quick reference.
Bookmarks