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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"excel_expert_wannabe" wrote:
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!