View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Auto Fill Series issue...

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