I have a work sheet in which cell E3 contains a data validation list with the name of cell ranges as the options (all cell ranges are 2 columns wide)
Then is cell C11 I have list data validation that is looking at the range in E3 for it validation options. =INDIRECT($E$3)
The only problem that I am having is that the data validation options in cell C11 are column 1 and 2 of the cell range when all i want is the first column.
What is the solution
Twmorgan
Bookmarks