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
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.