Generating values between two cell values

[andreasg]

Hi

I've tried searching for this, but I can't find anything that matches my question:

I have two cells with two values:

nr1: 10001000
nr2: 10001999

How can I make Excel generate all the numbers in between 1000 and 1999 in separate cells?


This is easy enough with just a couple, but I have about 800 "ranges" which I need to do the same thing

[ravishankar]

Hi
Assuming your start numbers are in col A and ending numbers are in col B, paste thef ollowing codes in the macro window ( Alt F11)

Please Login or Register  to view this content.

run the macro. It will generate numbers from Col A to col B 200 pairs per sheet and 4 sheets (sheet names should be sheet1, sheet2, sheet3, sheet4)
Ravi