I want to auto-populate a field with data from another sheet, but the kicker is the field I want to populate has a dropdown and I want to keep this.
1) The field being populated has a drop down. Normally I would use a simple VLookup to bring the data in, but the dropdown limits this.
2) I want to keep the dropdown. I want to keep the ability for people to change the populated data, but also want to restrict their options.
3) Have very limited experience with Macros (VBA). Is this going to require VBA?