| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please Help (Macro) or any other way
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.worksheet.functions
|
|||
|
|||
|
Please Help (Macro) or any other way
I'm a little unsure of where exactly you would like to insert a row.
There will be lots of rows between 10000 and 19999 for instance (11003, 15002 etc) Do you want to seperate the 10,000's? ie; 19000 19999 20000 21000 29456 30054 32487 ? On Dec 29, 2:04 pm, 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 manuallyThanks in advance for any help Vender Parts UPC Item Description QTY 11003 15002 17000 18000 19000 19999 20000 21000 25000 26000 26010 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please Help (Macro) or any other way
That's how I interpreted it, and provided code to do so in his same post of
same subject in the GQ forum: http://www.microsoft.com/office/comm...7-c768d396197a "bony_tony" wrote: I'm a little unsure of where exactly you would like to insert a row. There will be lots of rows between 10000 and 19999 for instance (11003, 15002 etc) Do you want to seperate the 10,000's? ie; 19000 19999 20000 21000 29456 30054 32487 ? On Dec 29, 2:04 pm, 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 manuallyThanks 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 | |||
| error when running cut & paste macro | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
Linear Mode
