I want to be able to collect information about 10 separate properties I
select at random. Address, year built, square footage, etc (about 14 line
items). I prefer to use a form on a worksheet, not userform if possible.
Since the information requested is identical for each of the properties, it
seems redundant to construct 10 forms. Is there an ingenious way to
construct one form, and based on the property number (1,2,3,etc.), transfer
the data to a corresponding column of cells labeled 1, 2, 3 etc. so I can
create a report that lists the information submitted for each property?
Thank you in advance.

Jim Kobzeff