Closed Thread
Results 1 to 4 of 4

Roll Off

  1. #1
    Registered User
    Join Date
    08-26-2008
    Location
    Oklahoma
    Posts
    24

    Roll Off

    Is there a way to set a number of rows on a page so as you add additional rows the ones at the top roll off?

    And how would you do it?

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    re: Roll Off

    What is the application?
    If you always need 20 rows and in case you add one, VBA can count these and "delete" the first so you'll keep the last 20.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    Registered User
    Join Date
    08-26-2008
    Location
    Oklahoma
    Posts
    24
    I thought that this was a place I could get some help but I get an infraction for a wrong title? Give me a break. Communist moderator.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Even communists require a sense of community, George. You want the anarchy forum. We'll look into starting one. Thanks for stopping by.
    Entia non sunt multiplicanda sine necessitate

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search for variable and copy row
    By tobeychris in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-26-2008, 10:38 PM
  2. Roll up data
    By agore03 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2008, 12:31 PM
  3. Roll Over Cell
    By Neight in forum Excel General
    Replies: 17
    Last Post: 08-17-2007, 05:38 PM
  4. Roll over cell
    By Neight in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-15-2007, 03:30 PM
  5. 1 from column A, 1 from column B - you get egg roll!
    By golfnutte in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2007, 02:21 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1