I have a spreadsheet which in some cases has duplicate entries (claim numbers)...Amount column does change (123 with $4.25, 123 with $1.25). I would like to write a macro which adds all $ with the same claim number and puts a summary information (123 WITH $5.50) under each claim series. My database has 10K records so using CLAIM SORT, SUB-TOTAL BY CLAIM ON AMOUNT would be very cumbersome. HELP !
This message was edited by brs2003 on 2002-03-21 06:55
This message was edited by brs2003 on 2002-03-21 06:55