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

--
Jim
"e3donald" 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:
http://www.excelforum.com/member.php...o&userid=33871
| View this thread: http://www.excelforum.com/showthread...hreadid=536500
|