If you have Access, move the data there (Access can import an Excel
spreadsheet) and create a report that will print a voucher (1 page) for
each record. Excel is a spreadsheet, not a database. What you want to
do would take a good bit of VBA coding.
Cheryl Wrote:
I have 2 pages in Excel sheet.

Sheet 1 contains database with information like voucher no. and name.
Sheet 2 is the form with blank fields.
The blank fields will pull the voucher no and name from sheet 1.

I would like the form (sheet 2) to pull the data in sheet 1 line after
line
after printing.
Eg. after printing the form using line 1 of the data in sheet 1, it
will
automatically pull line 2 data in sheet 1 and print the form.
after printing the form using line 2 of the data in sheet 1, it will
automatically pull line 3 data in sheet 1 and print the form
This continues till there is no more data in sheet 1.

Thank you


--
Bob Miller