I am trying to automatically sum all values with the same account ID.
I’ve tried using the SUMIF function but that required me to specif
what the account ID I would like it to search for. I would like th
macro to automatically search within a specific column and whenever i
finds a duplicated account ID, to sum the values of the duplicate
account ID. For example, if there are two account 900, one displayin
a positive 50 and the other a negative 25. I would like it to su
those two numbers together so that I only have one row showing fo
account 900.

Any help is much appreciated.

yale

--
Message posted from http://www.ExcelForum.com