Hello
I have been learning all about Dynamic Named Ranges recently and have bee attempting to integrate this into a drop down list for a holiday planner (which uses a combo box) I use for work.
I can get the drop down list / combo box working fine and I can get the Dynamic Named range to work (expanding and updating with new entries) However I cannot get them to work together.
In the attached example I have
Holiday Entry - A2 I added under the data validation / List =OFFSET(Sheet2!$B$3,0,0,COUNTA(B:B)-1)
However when I double click the combo box it doesn’t contain any entries.
In the cell below (A3) the drop down list / combo box works fine but the data validation is just aimed at a named range.
What I want to be able to do is have the combo box (enabling partial typing / name suggestion when you type in it) and Dynamic Named range (enabling the main list to be updated / modified and automatically update any drop downs) working together. I’m pretty sure it is possible, I just don’t know quite how
Hope that makes sense and someone might have a solution?
Thanks
Paul
Bookmarks