Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Script to insert row and calculate a range
Sorry, I am new to this. Please forgive my ignorance.
I recorded a macro that sorts items first by class (ie.108 or 217 located in column F) and then by dollar amount (located in column S). There may be 10 items in a class. I need the script to locate the last occurance of the class number (Column F) on the sheet and then insert a row below. The script needs to sum the dollar amounts in the new row in Column S. I would appreciate any help I can get. ~Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Script to insert Row | Excel Discussion (Misc queries) | |||
Need VBA script to auto-insert value upon row insert | Excel Worksheet Functions | |||
Insert a key function in VBA script | Excel Programming | |||
Script to insert the next Friday | Excel Programming | |||
insert excel vb script | Excel Programming |