Forum Discussion

gerasimos1023's avatar
gerasimos1023
Copper Contributor
Apr 01, 2022

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

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 !

excel
Macros and VBA

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Apr 01, 2022

    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:

    =LET(l_1,ROWS(F9#),
     spaces,2,
     l_2,ROWS(H9:H15),
    seq,SEQUENCE(l_1+spaces+l_2),
    IFS(seq<=l_1,INDEX(F9#,seq),
        seq<=l_1+spaces," ",
        seq,INDEX(H9:H15,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.

     

Resources