I would like to know if there is a way to fill in missing values when using autonumber in Microsoft Excel. For example, I have a list of numbers 1,2,3 etc all the way to 500. In between there are missing values such that it goes 5,6,9,12. Is there a way for excel to recognize these missing values (7,8,10,11) and insert rows for these numbers?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Autonumber With Missing Values
- Thread starter jorymf8
- Start date
Excel Facts
Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,084
- Office Version
- 365
- Platform
- Windows
Did you copy and paste the code I provided or did you try re-typing it?
If you re-typed it, check for typos (maybe try cutting and pasting the code now).
Otherwise, go into the VB Editor and "step" through the code. That is, use the F8 to cycle through your code line-by-line. Then you can see where it errors out.
By the way, do you have anything in column A at the bottom other than dates? That could be what is causing trouble.
If you re-typed it, check for typos (maybe try cutting and pasting the code now).
Otherwise, go into the VB Editor and "step" through the code. That is, use the F8 to cycle through your code line-by-line. Then you can see where it errors out.
By the way, do you have anything in column A at the bottom other than dates? That could be what is causing trouble.
Upvote
0
