Hi,

Im used to Excel but pretty new to VBA.

I have a table with 4 columns. A, B, C and D.

I wish to sum column C and D for different values in column A and B. And I would like to state these values everytime i activate the macro.

Example

column A = Salesperson, could be Johan, Kalle or Pelle
Column B = District, could be USA, Sweden or England
Column C = amount for each sale
Column D= Net win for each sale.

So when I run macro I would like to be asked to state Seller(one or more) and District (one or more). When declared Column C and D sums for these rows..

got it?

Very thankful for any kind of help