Hi All,

Can someone help me please. Rather than using Subtotals in excel to get the
sum of a number of common entries, can i use vba code to exacly this.

i.e

Column A has duplicate entries and also non duplicate entries and column B
has values, i want to sum up all the duplicate entries and non duplicate
entries to show just one entry in column A for each different entry and its
corresponding sum.

hope this makes sense.

thanks BigH