| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto insert rows in a list of numbers
I am working with a large list of numbers (between 0000 and 9999). The list has breaks in it that I need to fill without disturbing the data assigned to specific numbers. My question is if there is a way to get excel to automatically insert rows in this list to fill these gaps. This would save me many hours of work. Thank you in advance! Example below. Befo (what I have) 0001 ABC 0005 DEF 0006 GHI 0007 KLM 00011 NOP After: (what I need) 0001 ABC 0002 0003 0004 0005 DEF 0006 GHI 0007 KLM 0008 0009 0010 00011 NOP Joe Z -- zdek ------------------------------------------------------------------------ zdek's Profile: http://www.excelforum.com/member.php...o&userid=35510 View this thread: http://www.excelforum.com/showthread...hreadid=552822 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to identify a list of numbers as a publisher field | Excel Discussion (Misc queries) | |||
| how do I create a macro to auto insert rows? | Excel Worksheet Functions | |||
| Change a Column list into multiple rows & columns | Excel Worksheet Functions | |||
| How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
| HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) | |||
Threaded Mode
