I have a basic userform setup already that has contact info, etc. On one of the inputs, I am asking for a number of locations. Depending on this answer, likely 1-10, I want the user to then be taken to a second userform based on the number of locations input into form 1. If for instance, the user says 6 in this field, after hitting submit, I want the user to be taken to a form to fill out information for Location 1, then a form for Location 2, and so on until they are finished filling out the number of locations they specified.
I need all of that information posted into my worksheet in the specific sections with the same name (Location 1, 2, etc.)
How would I accomplish this task? I'm a noob to Excel, so go easy on me. I just figured out how to build a userform and have it post to the correct areas in my worksheet this morning.
On the other hand, if it's simpler, I could have the number of Location fields populate in the first userform based on the number chosen, so that it would all be one simple form, the length of which would change based on the input of # of locations. Either way, I could use some assistance.
Bookmarks