Hi Excel Forum
I have figured out how to create dependent drop down lists with the help of this forum (Offset option), but i would like to update/sort the lists automatically with any manual entries that might be added to drop down selections. Would I be doing this with VBA, and if so what would it look like? or is there an easier way. Your thoughts?
I have figured out how to create dependent drop down lists with the help of this forum (Offset option), but i would like to update/sort the lists automatically with any manual entries that might be added to drop down selections. Would I be doing this with VBA, and if so what would it look like? or is there an easier way. Your thoughts?