Add text at the last row of the last page of what is printed

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).
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.

Thank you in advance

This is also posted at https://www.mrexcel.com/board/…ted.1200879/#post-5861484

Hello royUK . Thank you again for your help

Sample attached.

Also posted at https://www.mrexcel.com/board/…00879/page-2#post-5861890 and https://www.excelforum.com/exc…an-excel.html#post5657901

Quote from royUK

Do you want it adding by the BuildInvoiceAll macro?

That needs checking though?

Or at the PrintCurrent. Is it possible? I can add text under the last row of the table at BuildInvoiceAll using this code

'Application.CutCopyMode = False
'Sheets("DATASET").Select
'LR10 = Cells.Find("*", Cells(1, 1), xlFormulas, xlPart, xlByRows, xlPrevious, False).Row
'Range("A1:E13" & LR10).Copy
'Sheets("FORM").Select
'lrAnotherSheet = Cells.Find("*", Cells(1, 1), xlFormulas, xlPart, xlByRows, xlPrevious, False).Row
'Cells(lrAnotherSheet + 1, 1).Select
'.HorizontalAlignment = xlCenter
'.VerticalAlignment = xlBottom
' ActiveSheet.Paste

But I was thinking if it can be addedd at the last page of the invoice (FORM), above footer , I mean at the last line and not exactly under the table.

Update! Finally I will do that with footers using this code

ThisWorkbook.ActiveSheet.PageSetup.LeftFooter = or RightFooter etc.

Thank you all for your effort and time wasted !

Cheers!