Hi,
I am looking for a way to set searchable dropdowns in a column with variable range. So, if a new row is added in the data source, then it should be found in the dropdown choices as well.
The searchable part I know how to do it, but I fail to setup the dynamic range. How can I approach this?
Many thanks in advance,
Paul
Is this a drop down in a cell via data validation?
One way to set up a dynamic named range is with a formula like this:
Formula:
Please Login or Register to view this content.
It will start at A2 (assumption is there's a header in A1) and end at the last populated row in column A (assuming there are no blanks in the data).
Then you can add or delete and the range will adjust to fit.
Although as this is in the VBA section, I may have missed the point a little
BSB
Last edited by BadlySpelledBuoy; 07-19-2018 at 06:58 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks