software

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


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:
gt; I have 2 pages in Excel sheet.
gt;
gt; Sheet 1 contains database with information like voucher no. and name.
gt; Sheet 2 is the form with blank fields.
gt; The blank fields will pull the voucher no and name from sheet 1.
gt;
gt; I would like the form (sheet 2) to pull the data in sheet 1 line after
gt; line
gt; after printing.
gt; Eg. after printing the form using line 1 of the data in sheet 1, it
gt; will
gt; automatically pull line 2 data in sheet 1 and print the form.
gt; after printing the form using line 2 of the data in sheet 1, it will
gt; automatically pull line 3 data in sheet 1 and print the form
gt; This continues till there is no more data in sheet 1.
gt;
gt; Thank you--
Bob Miller