Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Increment Rows in between numbers
Hello.
I have a spreadsheet that has a list of numbers on the left side (Column A) and I need to know how to create a macro that when I hit a button a row will insert in between the list of numbers and automatically fill in the number that goes there. If that makes sense. So if I have a list of 1-20 and I insert a row between 15 and 16, it will put 16 in that cell and put 21 at the end of the list. Thanks so much for you help. -- D |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
suspend auto increment | Excel Discussion (Misc queries) | |||
auto increment | Excel Discussion (Misc queries) | |||
DP Auto increment | Excel Worksheet Functions | |||
how to make excel auto enter increment invoice numbers. | Excel Discussion (Misc queries) | |||
How to auto insert rows in a list of numbers | Excel Discussion (Misc queries) |