software

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: www.excelforum.com/member.php...oamp;userid=33871
View this thread: www.excelforum.com/showthread...hreadid=536500I 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.I think you should fill down with a formula and then convert the result to
values using copy/paste special.

--
Jim
quot;e3donaldquot; gt; wrote in
message ...
|
| 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:
www.excelforum.com/member.php...oamp;userid=33871
| View this thread: www.excelforum.com/showthread...hreadid=536500
|
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(quot;A1quot;).Select
Do Until ActiveCell.Value = quot;quot;
ActiveCell.Offset(1, 0).EntireRow.Select
ActiveCell.EntireRow.Insert
ActiveCell.Select
ActiveCell.Value = ActiveCell.Offset(-1, 1).Value
ActiveCell.Offset(-1, 1).Value = quot;quot;
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
gt; wrote:

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