Is there a way to automatically update my dropdown list for a form if I have a new item added?
I have a New Order Entry form. I have a dropdown list of customers, but if it is a new customer, there is a checkbox to allow more fields to open up to enter that information. If that information is added, it gets copied to a Master Customer sheet.
Is there a way for my dropdown list to pull the customer names on my Master Customer sheet instead of me manually entering them into the dropdown list?
