D Debra Dalgleish Nov 8, 2003 #2 You can create a list of city names, and use the list as the source for the data validation dropdown. There are instructions in Excel's Help files, and on the following page: http://www.contextures.com/xlDataVal01.html
You can create a list of city names, and use the list as the source for the data validation dropdown. There are instructions in Excel's Help files, and on the following page: http://www.contextures.com/xlDataVal01.html
