Does anyone know if the options in a drop-down can be linked to a table?
I have a sheet that users can pick a "provider" from a drop down list. That provider is associated with a vlookup that helps to populate other columns in that sheet. However, the "provider" list is dynamic and changes when a new provider is added to the database. Right now, everytime that happens, I need to copy and paste the new list so that the drop-down contains the new name(s). Is there any way around that?