Just started working with excel and need help in populating a few drop down. I have an excel file with a spec sheet for T-Shirt. I would like to create drop down list for each selection from an access database. Base on the selection for that table, I would like for it to limit(dynamic) items for the next selection and so on. Pretty much just a filtering down of selections and give me the final product.
I need help with bounding each column in the database to a cell in excel as a dropdown. How to filter it so that it shortens the list down as selection is happening. Any examples would do. I provided an example excel file layout and access database. This is only a small portion of a huge project, and if I can learn how to accomplish this part, that would help tremendously. TSHIRT-SPEC.xls TShirt.mdb