Help to create a macro

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 :wave:

Quote:

---

Originally Posted by natstrom

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 :wave:

---

It would help to know more about the function of the sheet to be honest. From what you have stated all I would do is have a dynamic formula to give me the desired results in may be a summary page.

It all deoends on the amount of sellers and items you wish to sum. If you are able to post an example of your sheet here I can chuck something together for you?