Add text at the last row printed

[pantakos]

Hello,

I have a worksheet that collect data from various worksheets and insert them at a worksheet.
I need when I press print , a text that is in another sheet to be placed at the last printed page.
i.e. if the print is 3 pages then then text wil be placed at the bottom of the 3rd page. If 2 pages then at the bottom of the 2nd page etc.
I want the text to be placed at the bottom of the page and not right after the last filled row. (if the text is lets say 5 lines at the last 5 lines of the last printed page).

Thank you in advance

 

[sarathc]

Need more explanation.

 

[pantakos]

Ok, When I need to print the worksheet it can be 1 or 2 or 3 or even more pages to print.
I need at the last page that is going to be printed to enter 5 lines of text. Not under the last filled rows but at the very end of the printed pages.
As you can see at the attached picture the printing consists of 2 pages. At the 2nd page the marked space need to be at the bottom of the page.

The sheet may consist of 3,4, 5 pages or even more. I need the yellow marked shape to be placed always at the bottom of the last printed page.

 

[pantakos]

This is also posted at Add text at the last row of the last page of what is printed - OzGrid Free Excel/VBA Help Forum

 

[6StringJazzer]

I think your explanation is pretty clear but the image attachment is too low-res to be useful.

Do you need those last lines to be formatted in any special way, like the yellow fill you show? or just include the data?

This will require VBA to determine where the pages are and then insert the data. Do you have manual page breaks in your worksheet, or just let the pages break in their natural places?

 

[makis1023]

Thank you for your reply. I will try to upload a better pic. No I dont need any special format, no colors , just need 5 or 6 lines and to be copied from another sheet. I will upload the data also. Just these data will have formulas. I will upload a worksheet. No page breaks, natural pages

 

[pantakos]

Here is the sample workgroup
You can see 3 sheets, TEST1, FORM and DATASET
Test are the Data, Form is the one that collect the data and dataset is the one I need to to be placed always at the bottom of the last printed page.
There is also vba code that create the form , put the data from dataset under the last filled line of form and a print code for printing etc.
I cant upload it here so I will upload it at google drive.

SAMPLE.xlsm

TEST1 OTHER OTHER2 Stock,PRODUCTS,Book,Daily Rate TEST 1,1 TEST 2,24 TEST 3,47 TEST 4,70 TEST 5,93 TEST 6,116 TEST 7,139 TEST 8,162 TEST 9,185 TEST 10,208 TEST 11,231 TEST 12,254 TEST 13,277 TEST 14,300 TEST 15,323 TEST 16,346 TEST 17,369 TEST 18,392 TEST 19,415 TEST 20,438 TEST 21,461 TEST 22,484

docs.google.com

Thank you

 

[pantakos]

Thank you for your reply. I will try to upload a better pic. No I dont need any special format, no colors , just need 5 or 6 lines and to be copied from another sheet. I will upload the data also. Just these data will have formulas. I will upload a worksheet. No page breaks, natural pages

My Mobile connected me to a profile that my brother use, so the amswer from makis1023 its me @6StringJazzer . Sorry about that!

 

[RoryA]

Looks like this is also you?

How to force text to print at the bottom of the last page of an excel

Cross-posted at https://www.mrexcel.com/board/threads/add-text-at-the-last-row-printed.1200879 https://forum.ozgrid.com/forum/index.php?thread/1231329-add-text-at-the-last-row-of-the-last-page-of-what-is-printed/ Hello all and have a nice Month! I have a worksheet that works with...

www.excelforum.com

 

[pantakos]

Looks like this is also you?

How to force text to print at the bottom of the last page of an excel

Cross-posted at https://www.mrexcel.com/board/threads/add-text-at-the-last-row-printed.1200879 https://forum.ozgrid.com/forum/index.php?thread/1231329-add-text-at-the-last-row-of-the-last-page-of-what-is-printed/ Hello all and have a nice Month! I have a worksheet that works with...

www.excelforum.com

Yes, gerasimos is my real name and the account I have there is that one. Cross posting ? I will fix it asap. Is it problem to asl the same at different forums? Sorry about that