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