Zanatos1986
New Member
- Joined
- Apr 15, 2010
- Messages
- 48
Hey guys, I am trying to create a library in excel to help easily track all of our part under various categories.
I have a document with several sheets, one for each category. On my main sheet (user interface) I created a dropdown list with all these categories at cell E10.
Whenever someone selects this I would like for another cell to populate a list on the user interface sheet, cell E14, that shows all the parts for that category. I have the sheet setup but not sure of what code would make this work. It has been about 3 years since I have used VBA, so I am very rusty on it.
Any help will be appreciated!
I have a document with several sheets, one for each category. On my main sheet (user interface) I created a dropdown list with all these categories at cell E10.
Whenever someone selects this I would like for another cell to populate a list on the user interface sheet, cell E14, that shows all the parts for that category. I have the sheet setup but not sure of what code would make this work. It has been about 3 years since I have used VBA, so I am very rusty on it.
Any help will be appreciated!
