Automated form filling from a list

[Pees]

Hi all,

I have a report that needs to be filled and printed.
500 of those reports.
Data for them is in a sheet in form of a table.

What I need to do is to take a row from one sheet, put the data in another
sheet in correct places, print it, take next row, print it etc.

Any idea how can I do it using Excel only ?

Plan B is to make an application that using automation will do it using
those 2 sheets.
But I would prefer to do it simple as possible.

I would appreciate any concepts.

Best Regards
Pawel

 

[Bob I]

Why not just use Mail Merge in Word?

 

[Dave Peterson]

Maybe this stuff from Debra Dalgleish's site:
http://contextures.com/xlForm03.html
and maybe...
http://contextures.com/xlForm02.html

 

[Pees]

Thanks, very helpful links

Maybe this stuff from Debra Dalgleish's site:
http://contextures.com/xlForm03.html
and maybe...
http://contextures.com/xlForm02.html