View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cheryl
 
Posts: n/a
Default Printing of voucher

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