Excel does not allow you to keep your list on separate worksheets. All is not lost though, there is a way around this problem. You can simply name the cells on your other sheet, and then refer to the name in your data validation source.

Highlight the cells that you would like to be the source for your data validation drop-down. Select “Insert” from the menu, choose name=>define, name the range list. Go back to the worksheet that contains the cell that the data validation will be place in and open the data validation box. In the source data box for the list, enter =list. Your data on the other sheet will now be in your new drop-down.

Bookmark It

Related posts:

1. Excel Data Validation Data validation gives the Excel developer a way of dictating...
2. User Passwords in Excel - Multiple Passwords Simple multiple user password protection in Excel....
3. Referencing Data in Another Excel Workbook Q: Joe, I have data in another workbook that I...
4. #VALUE! Error in Microsoft Excel The #VALUE error is an error that is seen almost...
5. Conditional Formatting Q: Dear ExcelYogi, Thank you for all your wonderful advise...