I have a table which is dynamic in its rows and columns. Each row in the table represents a worksheet in the file. As time progresses the number of worksheets will increase. The first cell in the row (Column A) represents the worksheet name and the following cells represent columns within the worksheet (Column B to ....).
I am looking for a way to have two data validation lists to select a worksheet and column from the table.
The first data validation list is working correctly (it selects the worksheet using OFFSET in a named range). However I am unsuccessful in getting the second data validation list to work properly because it is dependent on the value of the first data validation list value selected, and the number of items in the second data validation list is not always the same. Also, the number of rows and columns in the table will be constantly changing.
I have attached a simplified table with data validation lists and how they should appear.
Can anyone advise how I can get the second data validation list to work correctly.
Thank you.
I am looking for a way to have two data validation lists to select a worksheet and column from the table.
The first data validation list is working correctly (it selects the worksheet using OFFSET in a named range). However I am unsuccessful in getting the second data validation list to work properly because it is dependent on the value of the first data validation list value selected, and the number of items in the second data validation list is not always the same. Also, the number of rows and columns in the table will be constantly changing.
I have attached a simplified table with data validation lists and how they should appear.
Can anyone advise how I can get the second data validation list to work correctly.
Thank you.
Last edited:
