How to create a form/macro that uses a drop down listing to populate/edit a data set?
I don’t mean in the sense of creating a list and using vlookup to relate values from another sheet. Rather I’m looking for a form/macro/add on that a user can basically open to add or edit individual lines of data - much like the “Form...” command but using a drop down list of items rather than manually typing in the value.
Posted Apr 3, 2019, 5:36 AM UTC
13
I have a short writeup on something similar yesterday. Is this close to what you are after?
Hi, I’m looking for something a little more user friendly as the data will need to be added to and/or edited by multiple people.
Ordinarily the ‘Form...’ command would be okay but because we’re dealing with so much data and from multiple people we want the inputs to not be manually typed but rather chosen by a controlled drop down list/menu.
that's ok.
if you had a sample of what you have and what you want to achieve, that would help me help you.