I have uploaded file ID 926644, which is the Excel workbook, I have also uploaded a screen shot of the list within the Access Database (file ID 419984).
When looking at the excel worksheet, on the left side, there are several labels, I am specifically working with cell G50, the label to the left of that cell says "Frame Color". I currently am using a list of cells, with a data validation tool to create the list, but due to the inventory always changing, I would prefer to use the updated list within the Access database. We update the list within the database, daily, and so if I added a new color within the database, I would have to go in and change the data validation within excel, as well, and see that as being very time sensitive.
So currently the user clicks the G50 cell, and the drop down arrow appears with the partial list I have inserted in the cells. If possible, instead of the data coming from within the cells, when the user clicks the G50 cell, it is pulling the data from the access database instead?
Is that any clearer, or did I make it muddier?