Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing of voucher
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |