Insert data at the end of page or last

Also posted at https://www.mrexcel.com/board/thread...-page.1202652/

Hello,

I need to insert data (text from another worksheet) at the bottom of the page. If data are only 1 page then insert at the bottom of that page, if there are more insert the data at the bottom of the last page.
The results to page 1 , page2 and the copied data to page 2 at the bottom. Can this be done?

Thank you

PS I had asked the same one month ago, I couldnt figure out a solution thats why I asked again. Please dont ban me!