VBA ComboBoxes to reduce search area

[cyrilbrd]

Given a table with 5 columns such as:

Ref	textjoin()	cat1	cat2	cat3
1	west_2024_status1	west	2024	status1
2	north_2024_status2	north	2024	status2
3	east_2023_status1	east	2023	status1
4	south_2024_status1	south	2024	status1
5	north_2023_status1	north	2023	status1
6	south_2023_status1	south	2023	status1
7	west_2024_status2	west	2024	status2
8	south_2023_status2	south	2023	status2
9	north_2023_status2	north	2023	status2
10	south_2024_status2	south	2024	status2

I have one combobox related to the second Column textjoin(), an OFFSET Named range fills up said combobox

I am looking into limiting the data based on two other combobox, here cat1 and cat2
So for example choosing "south" from the cat1 box:

And choosing "2023" from cat2 box:

Such would then limit the available search of the last box to here in this example only 2 entries:

I am not looking into filtering the table in any manner, the table structure is unchanged.
Any suggestion?

 

[Akuini]

Could you please upload a sample workbook (without sensitive data) to a file-sharing site like Dropbox.com or Google Drive, and then share the link here? Also, ensure that the link is accessible to anyone.