Forum Discussion

george christodoulou's avatar
george christodoulou
Copper Contributor
Sep 21, 2017

Page Layout and Page Break

Hello,

 

I would like to ask if there is any method that i could make different pages in the same sheet with the same layout. I would like to have an automatic system that could undersdant when i change the page and have the summary at the bottom. The page break will remain under the summary. Is there any way to do so or the only solution is the "manual".

 

Kind Regards,

George

excel

1 Reply

  • Scott Rogerson's avatar
    Scott Rogerson
    Copper Contributor
    Sep 22, 2017

    Can you attach a file, or explain this a bit more?  You could use VBA and press Alt-F11 to display the VB editor.

    1. Click the View menu within the Visual Basic Editor.
    2. Click Immediate Window from the View menu, or press Ctrl-G on your keyboard
    3. At this point the Immediate window will appear onscreen. This is a special area where any programming code you type will be executed immediately; hence the name.
    4. Type the following line of programming code into the Immediate window, exactly as written below, and then press Enter.

    Do Until Sheets.Count=X: Activesheet.Copy,ActiveSheet: Loop

     

    X=Number of sheets you desire.  As for the rest of your question, I am not sure until I understand better.

Resources