Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing in Excel overlaps previous text | Excel Discussion (Misc queries) | |||
How to change default printing parameters on Excel & ...... | Excel Discussion (Misc queries) | |||
Printing Recto/Verso | Excel Discussion (Misc queries) | |||
Cell borders printing black instead of grey | Excel Discussion (Misc queries) | |||
problem printing to PDF | Excel Discussion (Misc queries) |