I'm a full-time motorhomer and trael from campground to campground after making reservations.
My SS includes date in, date out campground info.
To populate the registration range I created a mileage chart to automatically populate a a range called distance (from campground A to campground B)
I use a dropdown list pointed at the campground range to populate name, address, city and state.

I would like to select from the dropdown list a campground, if the campground doesn't exist a form pops up to fill in name, address, city, state,zip and
adds the information to my mileage chart and then sorts by row and column.
I have campground row and column using vlookup to find mileage between campground A and B.