View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rlee1999 rlee1999 is offline
external usenet poster
 
Posts: 23
Default 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