Forum Discussion
Excell multiple print
Hi
I have 2 sheets
1st sheets invoice format
2nd sheets data
By lockup function I returned data sheet, data to the invoice sheets ...
But now I want to print all data sheet, data like invoice sheet format by one click ...
There in the data sheet maybe 100 row or 10 rows, its unknown and belongs to the daily data.
Tanx
I have 2 sheets
1st sheets invoice format
2nd sheets data
By lockup function I returned data sheet, data to the invoice sheets ...
But now I want to print all data sheet, data like invoice sheet format by one click ...
There in the data sheet maybe 100 row or 10 rows, its unknown and belongs to the daily data.
Tanx
7 Replies
Hi Fazalahmad
I think the easiest way to do that is to define a print section.In the invoice, insert data rows as a Excel Table. Then select the invoice area and define as print area.
The Table will be as large or short as the number of rows contained, and automaticly the print area dinamicly change the size of it.You can see in the example adding more values to the Table.
Regards,
CarlosF
- Tanx from the your reply
I have 2 sheets by the name (invoice and data ) in the one workbook of excell
Invoice sheets
It's have one page a4 and in that page include all the invoice information (invoice no, details, contact, number, amount, etc..)
When I change the invoice number automatically that information is changing...
This pages don't have any prob in the printing and in the return data from the another sheets..
2nd- my second sheet is the invoice data sheet or invoice list like
Invoice no, name, amount....
In the this sheet maybe 20 or 100 rows...
However my problem is here
I want a button when I click on that, that button can to return all date from the data sheets to the invoice sheet and prints all of them.. shortly I wants to print all data sheet list like the invoice format shhet by one click..- Can you add the Excel file without private info?
