LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using auto fill edit or fill handel fill handle or auto fill Excel Worksheet Functions 0 February 10th 06 07:01 PM
Edit Fill Series - How do I fill using minute increments IUnknown Excel Discussion (Misc queries) 1 January 29th 06 12:50 PM
Excel should not automatically extend series or fill values whisperlm Excel Discussion (Misc queries) 0 July 13th 05 07:06 PM
Auto fill color change Dave Excel Discussion (Misc queries) 4 June 15th 05 05:45 PM
Fill Series option grayed out kodismom Excel Discussion (Misc queries) 1 June 1st 05 01:06 AM


All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"