Excel Spread Sheet Help

[dciscokid23]

I've also posted this in the Micosoft Office forum:

Help please, I did not see an answer to my question anywhere (here or google), please forgive me if I missed it...

My problem is I have an excel document with rows number sequentially BUT some of those number are "missing" and I would like to do 2 things:
1) insert a row and 2) enter the next sequential number when it is not there. For example my excel worksheet has:

22143
22145
22151
22152
22155

And I'd like it to insert a row with the next number where missing like below:

22143
22144
22145
22146
22147
22148
22149
22150
22151
22152
22153
22154
22155

I actually have multiple worksheets with the same issue and thousands of numbers. (I am in telecom and this is for an extension database which could be from 10000 to 999999)

I've seen help for almost every other row insert except what I really need.
Thanks in advance,

 

[micang]

Do you have MS Access, I would probably do it there rather than in excel.

I would create a complete list of sequential numbers in a table. i would then import the data from excel into a table. Then I would do an outer join to get the result you need and export back to excel.

Thanks
Michael

 

[SkipVought]

I just posted a solution in your original thread in forum68.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]