MrBigglesworth
New Member
- Joined
- Jun 4, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi All,
I apologise if the answer is already here in the forums but i've struggled to even find the words to search for the correct answers.
So, my example data is a list of locations in the UK and next to each one is the region they belong to. So Column A, list of locations and Column B is the region those locations below to.
What i would like to achieve is to be able to have a fixed list of regions in ComboBox1 and when i select 'North East' from ComboBox1, the ComboBox2 dropdown list is populate with only the locations that belong to that region.
So for example, i select North East from ComboBox1 and the list in ComboBox1 reads Alnmouth, Amble, Ashington, Durham, Newcastle. If i chose North West it would pick out Carlisle, Penrith, Sedbergh, Orton to at the list items as they have 'North West' next to them in column B.
I can only describe it as paying attention to Column B and returning the values of Column A much like a SUMIF would only calculate items in column A based on matching criteria in column B
In practice, the locations per Region would be several hundred in case that impacts anything in terms of combobox rangefill limitations.
Many thanks for any advice given
Mr B
I apologise if the answer is already here in the forums but i've struggled to even find the words to search for the correct answers.
So, my example data is a list of locations in the UK and next to each one is the region they belong to. So Column A, list of locations and Column B is the region those locations below to.
What i would like to achieve is to be able to have a fixed list of regions in ComboBox1 and when i select 'North East' from ComboBox1, the ComboBox2 dropdown list is populate with only the locations that belong to that region.
So for example, i select North East from ComboBox1 and the list in ComboBox1 reads Alnmouth, Amble, Ashington, Durham, Newcastle. If i chose North West it would pick out Carlisle, Penrith, Sedbergh, Orton to at the list items as they have 'North West' next to them in column B.
I can only describe it as paying attention to Column B and returning the values of Column A much like a SUMIF would only calculate items in column A based on matching criteria in column B
In practice, the locations per Region would be several hundred in case that impacts anything in terms of combobox rangefill limitations.
Many thanks for any advice given
Mr B
