| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
Hello,
Could someone please help me with a macro that will insert a row between Groups of Numbers. I would like to be able to insert a row between =10000 and <=19999, =20000 and <=29999, =30000 and <=39999, =40000 and <=49999, =50000 and<=59999 and so on upto 100000. I export this from Quickbooks and have to insert rows manually Thanks in advance for any help Vender Parts UPC Item Description QTY 11003 15002 17000 18000 19000 19999 20000 21000 25000 26000 26010 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Help
Code provided with your post on this subject in the GQ section.
"Mike" wrote: Hello, Could someone please help me with a macro that will insert a row between Groups of Numbers. I would like to be able to insert a row between =10000 and <=19999, =20000 and <=29999, =30000 and <=39999, =40000 and <=49999, =50000 and<=59999 and so on upto 100000. I export this from Quickbooks and have to insert rows manually Thanks in advance for any help Vender Parts UPC Item Description QTY 11003 15002 17000 18000 19000 19999 20000 21000 25000 26000 26010 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
