Good morning to all,

I have a question regarding data validation. This is my situation: I have a very extensive horizontal list of values that I would want to appear in a list (possibly a thousand or more). However, under each column heading, there are values (around 20 or so), varying for the different column headers.

The objective is to create two validation lists. The first is to choose the column header while the second allows you to choose a value that is underneath that column header.

The main problem I have encountered is that I would need to provide a name for each column's values, however with the large amount of columns I have, this would not be time efficient, so I'm searching for an alternative plan, whether it is a simple formula or a macro.

Thank you very much in advance,


Dave.