Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Rolling copy? (2003)

    At least I used to refer to it as a rolling copy...
    I'm remembering back in the Lotus 1-2-3 days, there was a "feature" whereby you could copy range A1:A90, say, into cell A11. What happened was that A1 was copied to A11, A2 to A12, ... A11 to A21, etc. The net effect was that the formulas in rows 1 thru 10 were repeated 9 times down the spreadsheet.
    I have always assumed that there's no way to do the equivalent in Excel, but thought I'd ask...
    TIA

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rolling copy? (2003)

    Select cells A1 to A10. Grab the fill handle in the lower right corner of the selection. Drag it down to A90. Does that do what you want?
    Legare Coleman

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Doh!

    Yes, that does exactly what I want. And like a lot of things, it's obvious once you're told the answer!
    Many thanks... but next time could you respond a little quicker? Four minutes is totally unacceptable...

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Doh!

    Easy there. Legare had to tie Hans' hands behind his back to answer first. <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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