• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

The possibility of linking the footer of the Excel page to the data and not always at the bottom of the paper

Hany ali

Active Member
hello every one,i want your help ,if it Possible to fixing the footer for ever Page In excel sheet after one Row From the end of Data not apper as usual in the Bottem from the page
thanks and Best Regards
Prepare ReviewManaging Director
( )
( ) ( )
and this fotter ,inside sheet2 -Range ("O1:S2")
 

Attachments

  • 1.png
    1.png
    212 KB · Views: 5
  • 2.png
    2.png
    193.4 KB · Views: 5
  • Footer.xlsm
    20.4 KB · Views: 4
Hany ali
Do You need the footer?
or
would You use to add 'like-footers' to correct places (in the end of every sheet) before 'print-out'?
... and clear those 'like-footers' after 'print-out'
 
THANKS MR,
vletm
OF Course i want this Footer which i made in my file ,But I want after data directly when i Print out,not as Usual in the Bottem if the last Page from Pritring as just half data not full data ,i want after the last Row of Data
yes i want to add this Footer in the End of evert Sheet ,but Not in the Bottem Before Print out
and no problem about Clear ,or Not
thanks again for You Replay
 
Hany ali
Term 'Footer' means 'Footer'
... but as I tried to explain
a) DO NOT use Footer!
b) before 'printout' You add three lines to every '50' row from the end (after rows: 131, 104 & 54
... and same time copy as Your needed 'as-footer' there' (from eg other sheet)
... ps You also have to edit pages bottom margin to zero!
c) printout
d) delete those added three line 'as-footers' ... then Your sheet looks as normally.
 
Hany ali
It's necessary to get answers that could help You.
What is the same in Bottem?
Here so call 'manual-footers'
Screenshot 2019-11-11 at 11.22.02.png

Screenshot 2019-11-11 at 11.22.16.png

Screenshot 2019-11-11 at 11.22.31.png
I added control for PrintRange, then it would printout all rows.
 

Attachments

  • Footer.xlsm
    32.2 KB · Views: 4
Hany ali
When did You check that situation?
My file won't use NORMAL FOOTERS as in Your png-file!
Have You added Your printing routines as I've tried to help?
Some of Your page settings would need modify...
Here is sample PDF- routine.
with Excel-file (which really do not use NORMAL FOOTERS as default! )
 

Attachments

  • Hany ali.pdf
    55 KB · Views: 1
  • Footer.xlsm
    33.5 KB · Views: 2
I Try alot of time to make it as Pdf Forme ,which You Sent -But I Failed
Yes I want like Pdf Forme ,but I Can't to make it in excel sheet
 
Hany ali
Do You know what are You writing ... testing ... or something?
That my the newest file creates PDF ... which You haven't wanted before Your #12reply.
It should work, if You can create PDF with Your Excel ...
As I wrote ... You should test my modifications with my the newest file
... if You're continue testing with Your own file ... then my modifications won't work!
Is there something missing still?
Ps Sentences which ends with ? ... are questions ... and You should give answers.
 
Hany ali
Footer
... those can see/use only while output ... otherwise no!
If 'manual-footers' stays there ... then there will be other challenge if You'll [ Print ] or anyway run that macro again.
Term 'my file' is eg file which I've sent for You.
Your previous snapshot was take from You maybe original file ( there were still 'normal footers' ).

As I've tried to as few times:
Do You know, what are You writing ... testing ... or something?
It's challenge to help You if You cannot explain WHAT?
If You try to 'copy & paste' some parts eg from my code then ... good luck.
... but You should know what will happen if not the whole code.
 
Have You checked my previous sent file?
... why You cannot use that file?
... or You should compare my file and Your file ... if something is different, then modify Your file as my file.
 
i think ,it was some confused between you and me
about Print Button when i Press for it it should be Print or Not ?!!
because with me Not Print,may be this the reason
and I Used Excel 2016
this photo when i Press Print Button just this MSG Box without any Printout for the sheet
and I will Try again to make it
 

Attachments

  • Untitled.png
    Untitled.png
    144.3 KB · Views: 1
Last edited:
Hany ali
Do I have any words anymore ... ?
Seems that You have skipped or You do not remember anything that I have written...
> reply #4 - tried to show basic procedure
> reply #6 - my 1st sample file ... and of course, seems that You have not tested nor tried to read that code ... hmm?
> reply #10 - ... still You have not checked my code or You do not have any idea of below part of code... hmm?
Code:
'   BELOW YOUR PRINTOUT ROUTINES
        Application.ScreenUpdating = True
        MsgBox "Printing..."
        Application.ScreenUpdating = False
'   ABOVE YOUR PRINTOUT ROUTINES
> reply #11 - Did You even try to read that?
There were one sentence That my the newest file creates PDF...

Yes, Your #17 reply refers to OLD OLD versio ...
Other Your comments were that Your OWN ORIGINAL file didn't work
... and ...
I tried to modify my files
...
When do You start to answer to my questions?
...
Your: Print or not?
NOT!
... because I didn't get any idea how to send a sample of printed results!
 
Hany ali
I ... want ... answers

Next ...
read very carefully
use ONLY this file!
do ONLY next steps!
1) save next file to Your harddisk
2) open it
3) press my [ Print ]-button
4) check Your printer
 

Attachments

  • Footer.xlsm
    33.5 KB · Views: 6
Back
Top