Mar 31 2022 11:51 PM
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 !
Apr 01 2022 05:33 AM
@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.