| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
insert row and add functions
I'm trying to write a macro to loop through rows in a large range.
When it determines that, for example A2 < A3 it inserts two rows. It then counts number of records in that section SUMS all the numbers in this section. i.e above first newly inserted row back to last blank row. 2006/02/14 65 Apples 2006/02/14 43 Apples 2006/02/14 43 Apples 2006/02/14 43 Apples 2006/02/14 43 Apples 2006/02/15 22 Apples 2006/02/15 11 Apples Would then become 2006/02/14 65 Apples 2006/02/14 43 Apples 2006/02/14 43 Apples 2006/02/14 43 Apples 2006/02/14 43 Apples 5 237 2006/02/15 22 Apples 2006/02/15 11 Apples 2 33 Apples Any assistance would be very helpful I've just about got inserting blank row..it's the next bit that's :-(. Cheers |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
insert row and add functions
Instead of doing the code have you looked into subtotaling or a pivot table.
My preference for those kinds of things is a pivot table. You can make multiple pivot tables off the same source data and also you could group your items by day, month, year... It makes for a much more dynamic and user friendly report. Not to mention by adding a format it will amaze and delight anyone you send it to... -- HTH... Jim Thomlinson "gazeteer" wrote: I'm trying to write a macro to loop through rows in a large range. When it determines that, for example A2 < A3 it inserts two rows. It then counts number of records in that section SUMS all the numbers in this section. i.e above first newly inserted row back to last blank row. 2006/02/14 65 Apples 2006/02/14 43 Apples 2006/02/14 43 Apples 2006/02/14 43 Apples 2006/02/14 43 Apples 2006/02/15 22 Apples 2006/02/15 11 Apples Would then become 2006/02/14 65 Apples 2006/02/14 43 Apples 2006/02/14 43 Apples 2006/02/14 43 Apples 2006/02/14 43 Apples 5 237 2006/02/15 22 Apples 2006/02/15 11 Apples 2 33 Apples Any assistance would be very helpful I've just about got inserting blank row..it's the next bit that's :-(. Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nested functions using insert function | Excel Worksheet Functions | |||
| Insert column : lose inclusion in functions | Excel Worksheet Functions | |||
| It is some functions who insert rows? | Excel Worksheet Functions | |||
| Insert Functions | Excel Discussion (Misc queries) | |||
| User functions and the Insert-Function dialogue | Excel Programming | |||
Linear Mode
