+ Reply to Thread
Results 1 to 4 of 4

Auto Fill Series issue...

  1. #1
    Registered User
    Join Date
    04-26-2006
    Posts
    1

    Auto Fill Series issue...

    I have what is probably not an entirely unique question.
    Background: I have two sets of data -- (1) Consecutive numbers 50000 - 52499 (2) Consecutive numbers 60000 - 62499
    Thanks to auto-fill series, I didn't have to key in two sets of 2500 numbers....however, now I need ONE worksheet with both sets alternating from low to high. Example:
    50000
    60000
    50001
    60001
    50002
    60002
    and so on.
    Without formulas (as this is not an option for my usage), is there a way to auto-fill this series? I have even tried the questsin add-in, but no results were found.
    Any help would be appreciated.
    Thanks.

  2. #2
    Jim Rech
    Guest

    Re: Auto Fill Series issue...

    I think you should fill down with a formula and then convert the result to
    values using copy/paste special.

    --
    Jim
    "e3donald" <e3donald.26vu4m_1146073201.6236@excelforum-nospam.com> wrote in
    message news:e3donald.26vu4m_1146073201.6236@excelforum-nospam.com...
    |
    | I have what is probably not an entirely unique question.
    | Background: I have two sets of data -- (1) Consecutive numbers 50000 -
    | 52499 (2) Consecutive numbers 60000 - 62499
    | Thanks to auto-fill series, I didn't have to key in two sets of 2500
    | numbers....however, now I need ONE worksheet with both sets alternating
    | from low to high. Example:
    | 50000
    | 60000
    | 50001
    | 60001
    | 50002
    | 60002
    | and so on.
    | Without formulas (as this is not an option for my usage), is there a
    | way to auto-fill this series? I have even tried the questsin add-in,
    | but no results were found.
    | Any help would be appreciated.
    | Thanks.
    |
    |
    | --
    | e3donald
    | ------------------------------------------------------------------------
    | e3donald's Profile:
    http://www.excelforum.com/member.php...o&userid=33871
    | View this thread: http://www.excelforum.com/showthread...hreadid=536500
    |



  3. #3
    Dave O
    Guest

    Re: Auto Fill Series issue...

    I would do this by inserting a column to the left of each filled
    series, and numbering the rows from 1 to 2500, so they would look like
    this:
    Col A Col B
    1 50000
    2 50001
    etc
    2500 52499
    ....
    1 60000
    2 60001
    etc
    2500 62499

    I would then copy the first set of numbers (A1:B2500) into the desired
    location, and copy the second set of numbers directly under the first
    set. Highlight the entire range, and sort on column A and secondarily
    on column B.

    Just one way to skin this cat.


  4. #4
    Gord Dibben
    Guest

    Re: Auto Fill Series issue...

    No formulas??

    How about a macro?

    Assuming you have your two columns of numbers in A and B

    Sub CombineCols()
    'combine 2 columns to one with data from Col 2 being inserted
    'between data from Col 1
    Range("A1").Select
    Do Until ActiveCell.Value = ""
    ActiveCell.Offset(1, 0).EntireRow.Select
    ActiveCell.EntireRow.Insert
    ActiveCell.Select
    ActiveCell.Value = ActiveCell.Offset(-1, 1).Value
    ActiveCell.Offset(-1, 1).Value = ""
    ActiveCell.Offset(1, 0).Select
    Loop
    End Sub

    Will take a while on a slower computer so be patient.


    Gord Dibben MS Excel MVP

    On Wed, 26 Apr 2006 12:37:24 -0500, e3donald
    <e3donald.26vu4m_1146073201.6236@excelforum-nospam.com> wrote:

    >
    >I have what is probably not an entirely unique question.
    >Background: I have two sets of data -- (1) Consecutive numbers 50000 -
    >52499 (2) Consecutive numbers 60000 - 62499
    >Thanks to auto-fill series, I didn't have to key in two sets of 2500
    >numbers....however, now I need ONE worksheet with both sets alternating
    >from low to high. Example:
    >50000
    >60000
    >50001
    >60001
    >50002
    >60002
    >and so on.
    >Without formulas (as this is not an option for my usage), is there a
    >way to auto-fill this series? I have even tried the questsin add-in,
    >but no results were found.
    >Any help would be appreciated.
    >Thanks.



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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