View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
e3donald
 
Posts: n/a
Default 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.


--
e3donald
------------------------------------------------------------------------
e3donald's Profile: http://www.excelforum.com/member.php...o&userid=33871
View this thread: http://www.excelforum.com/showthread...hreadid=536500