Is there a way to do this on a worksheet?
 

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

Is there a way to do this on a worksheet?
 

Jim,

It sounds as if you have a bona fide table. If so, Autofilter can be a good
way to round up, summarize, and print select rows. Even if you have to roll
your own by putting something in an empty column put there for that purpose.
For example, you could have such an ad hoc column, and simply put anything
in it, then Autofilter for not blank.
--
Earl Kiosterud
www.smokeylake.com

"JK" wrote in message news:b2RJe.2100$0d.1529@trnddc03...
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