I created a user form and I have two fields that I now want to automatically fill with data from same spreadsheet. If I input data into Columns A and B is there a way to have that data populate into my form automatically? The fields are Facility ID and Facility Name. These two fields I will manually input so the user doesn't have to do that step. I'm just not sure how to have them auto populate on the form when they go to insert new data (using the form).
Currently these two fields get entered into the form and populate into the same columns that I can manually input the data.
Hopefully this makes sense. It is kind of hard for me to explain.
Thanks
Zach
Currently these two fields get entered into the form and populate into the same columns that I can manually input the data.
Hopefully this makes sense. It is kind of hard for me to explain.
Thanks
Zach