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

Occasional Visitor

Hello all, 


I have a worksheet that works with tables and I filling it with data from other sheets. How can I force text to be printed at the bottom of the last page of the sheet that is going to be printed. I dont want it to be placed in footer but at the same page (last page, the print area will be 1 or 2 or 3 or even more). 

Furthermore, Can I grab data from another sheet and place them at the bottom? Not a single text , but maybe 4-5 lines.


Thank you !

1 Reply

@gerasimos1023 So someone else here may have a better solution but I did something like this for one of my projects.  Basically I did all the references to other sheets and fixed values.  Then I had a table of values and needed to add a disclaimer after that table.  So I created this:

        seq<=l_1+spaces," ",

So basically my dynamic table was 'built' at F9 (so F9# refers to a dynamic length of rows)

I added 2 'spaces' lines

Then i add the disclaimer in cells H9:H15.

I hope this helps give you an idea how it might work for you.