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 s...
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..
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?
- If you can't see the option to upload a file, then upload it to an online service as gdrive, Onedrive... and share the file.
(I think it is not a good idea to publish your phone number...).