Does anyone know how to apply a dependant drop down to a whole column? I've been doing it through data validation and the indirect function but it takes such a long time. Any advice or guidance would be greatly appreciated.
Thanks.
Does anyone know how to apply a dependant drop down to a whole column? I've been doing it through data validation and the indirect function but it takes such a long time. Any advice or guidance would be greatly appreciated.
Thanks.
What do you mean "takes such a long time"? Applying it, or does it slow down your processing?
You can use a cell reference in the DV, along the lines of
=INDIRECT(A1)
which would reference the ranges named in column A of each row, or
=INDIRECT($A$1)
which would reference A1 for every cell.
The other option would be to use VBA code and the change event to apply the DV to a cell based on an entry or entries in other ranges.
Bernie Deitrick
Excel MVP 2000-2010
Applying it. Thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks