I am building a data entry grid in excel. Certain Fields I want to limit to a list of values. These values will contain anywhere from 10 to 1000 values. I want to use the validation list to limit the values in the cell to one of the values in the list but I am can not figure out how to attach the range of the cells (which is on another worksheet within the file in the source field of the validation pop up box. Any suggestions
Named Range = Private_label or =Tables!$A$2:$A$25
Thanks
Named Range = Private_label or =Tables!$A$2:$A$25
Thanks