I have an existing non Consecutive column of numbers that I need to make Consecutive. How do I insert the missing numbers in additional rows while preserving the other columns of data that go with the already existing rows? Below is a small example.
The numbers in the right column are the ones I want to make consecutive.
F-1366 763481
P-2464 763484
PD-1310 764416
Thanks very much.
could you please attach a workbook with about 10 lines of data?
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
And what do you want to happen to the values in the left column? Repeat? Blank? In your small sample, would you expect to see the following as the result:
F-1366 763481
F-1366 763482
F-1366 763483
P-2464 763484
P-2464 763485
P-2464 763486
P-2464 763487
P-2464 763488
.
.
.
P-2464 764414
P-2464 764415
PD-1310 764416
?
I have attached a small sample. and as ask by another person, I want the left column of extra rows to be blank.Originally Posted by DGagnon
I would like the left column of extra rows to be blank.
Thanks Paul
This macro should do the trick for you
but one note is that there are 931 rows that will be added between your last and second last entry.
Please Login or Register to view this content.
Last edited by DGagnon; 03-23-2012 at 05:56 PM.
Another option, without looping through every cell (inserting a range of rows and filling via series):
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks