dciscokid23
MIS
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,
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,