Hi everyone, I have a excel sheet and need to create a drop down box/ combo box in Excel 2010.
There is two columns that contain the data, 'ID' and ';Locations' I'd like the dropdown box to be populated with Location's column but when the user selects a location instead of saving the name of the location, its save's the Unique ID.
Is this possible?
Bookmarks