| 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 |
| 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 | |||
Threaded Mode
