Some assistance please.

Column A: list of string values with duplicates and can contain blanks.
Column B: a numeric value associated with the adjacent cell in Column A

Using VBA I want the unique values from Column A entered in Column C and the total of the values from Column B entered in Column D aligned with the associated value in Column C.


Thanks
ron