Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Spread Sheet Help

Status
Not open for further replies.
Mar 11, 2004
35
US
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,
 
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
 
I just posted a solution in your original thread in forum68.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top