I have roughly 20 lists in my workbook. Examples: "2FootLamps" "3FootLamps" "4FootLamps"
List Name "2FootLamps" has the following values: 1L2 - 2L2 - 3L2 - 4L2
I would like to do the following:
(A1) is my reference cell and will contain a validation of all the list names...