I have a spreadsheet that will be used to upload data to an Access database. After the user inputs the new product number (col A) and product description (col B), they will choose the "Value_Title" (col C) from a drop-down list of unique values (sorted alphabetically). The user will then select the "Value" (col D) from a drop-down list of unique values (sorted alphabetically) which is the possible values based on the choice in col C.
In the database there are over 100 unique possibilities in the field "Value_Title".
The ODBC connection to the db is set to automatically refresh when the workbook is opened.