It also shows how to create a dropdown from another workbook, edit and delete data validation lists. Excel drop-down list, aka drop down box or combo box, is used to enter data in a spreadsheet from a pre-defined items list.
In Excel, you can create a drop down Data Validation list, so it’s easy to enter valid items in a cell. Usually, the list of valid items is stored in the same workbook, but it’s possible to set up a drop down from a list in another workbook.
I used data validation including drop-down lists in the 2007 format of Excel. when i open the workbook in 2003 format, the validation does not work. Please assist in recifying this without having to redo the entire workbook.