Automatically populate forms

[excel_expert_wannabe]

Hi,

I'm trying to automatically populate forms and I can't figure out how to do
this. I have about 243 data records and I'd like to format each record in a
particular layout. In order to save lots of time, I'd like to create a form
that automatically pulls from each subsequent line in the dataset on separate
tabs. Anyone have any help for me?

Thanks!

 

[Max]

It's quite tough to visualize what you have/seek to do ..

Could you upload your sample file/data/expected results
using a free filehost, then post a link to it here?

Eg, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here

Then again, perhaps a possible close?? fit to your query ..

Try my recent response to another poster at:
http://tinyurl.com/68rjwo

There's also a nice sample file which illustrates:
http://www.savefile.com/files/1600987
AutoCopy Lines by Key Col to Resp Sheets.xls