Repeat Last Row Of Each Page At The Top Of Next Page

    I want to have the last row of every page repeated (exactly the same) at the top of next page.
    e.g
    .
    .
    .
    page 1 -last row - 55: (col A) TOTAL 1st page (col B) 1000 [=sum(B2:B54)]
    -------------------------------------------------------------------------
    page 2-first row - 56: (col A) TOTAL 1st page (col B)1000 [=sum(B2:B54)]
    .
    .
    .


    page 2 -last row - 110: (col A) TOTAL 2nd page (col B) 2500 [=sum(B57:B109)]
    --------------------------------------------------------------------------
    page 3 -first row -111:(col A) TOTAL 2nd page (col B) 2500 [=sum(B57:B109)]
    .
    .
    .etc
    Is what I am asking clear? I would appreciate if enybody could help...Thanks in advance

    Re: Repeat Last Row Of Each Page At The Top Of Next Page


    nikma,


    I think you will find you can only specify one contiguous range to repeat at the top of a page using page setup. If you can't, you may have to insert rows that duplicate the row above. This can be automated but would require knowing the page breaks in advance which is beyond my VBA skills. Try searching page break because I'm sure someone knows.


    Jim

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login