Results 1 to 8 of 8

Thread: Repeating Format Automatically On Scrolling Down To New Page

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    So if I understand correctly, each of your pages would be say around 45-50 rows in height, and by scrolling you mean moving the cursor down the sheet using the arrow button on the keyboard (and not just dragging the vertical bar down, cause that doesn't move the cursor, and in turn there's no trigger event to it). And the moment the cursor reaches the next page, you want the border from the first sheet to be exactly copied over to the page you are on now. Am I guessing your objective correctly?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  2. #2
    Junior Member
    Join Date
    Jun 2013
    Posts
    13
    Rep Power
    0
    Quote Originally Posted by Excel Fox View Post
    So if I understand correctly, each of your pages would be say around 45-50 rows in height, and by scrolling you mean moving the cursor down the sheet using the arrow button on the keyboard (and not just dragging the vertical bar down, cause that doesn't move the cursor, and in turn there's no trigger event to it). And the moment the cursor reaches the next page, you want the border from the first sheet to be exactly copied over to the page you are on now. Am I guessing your objective correctly?
    I don't think so.

    Here's a picture of what I need repeated for each page:
    Example.jpg

    I have the "Header" and "places" as repeated print rows, but I need the info tables to repeat each time I go to a next page as well. I can fit seven of the info tables on one page after the printed rows (Header and places).

    Basically, I do not want to copy/paste the info tables each time I need a new page. I want it to automatically have the tables be there just like the printed lines, but while still having the ability to enter information into them.

Similar Threads

  1. Did You Know:: Synchronized Scrolling, Comparing Workbooks Side by Side
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-26-2013, 10:42 PM
  2. Replies: 3
    Last Post: 04-05-2013, 08:24 AM
  3. Convert Text In YYYYMMDD Format To Date Format
    By S M C in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 02-28-2012, 12:04 AM
  4. Scrolling Marquee text on Userform
    By Mechanic in forum Excel Help
    Replies: 1
    Last Post: 12-08-2011, 07:24 AM
  5. Capture values from IE page
    By maruthi in forum Excel Help
    Replies: 6
    Last Post: 11-22-2011, 08:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •