How To Add or Sum Up Data For a Given Month (Selected in a Combobox) With VBA Code

[kelly mort]

I will want the summed data to be displayed onto another sheet, sheet2. And should look like this:

The original data is on sheet1 and looks like this:

And here are the logics that I want to apply:
1. Loop through col A for dates that match selected in a combobox (say cb1) on a userform. The cb1 has the months in the form:
JAN, FEB, MAR, etc.
Example, 27-01-21 matches JAN.

2. The next move is to get the totals for each single item within the said month.
* The only challenge here is that various dates might have different listings altogether. That is 26-01-21 might have:

SALARY        20
KITCHEN      110
RENT            34
CULTURAL    8

While 28-01-21 might have:

 GENERAL EXPENSE           45
SALARY                              78
CULTURAL                          7
KITCHEN                             39

So let say the month of January has only these two dates in my database, then I want to display on the sheet2 this:

RENT                                  34
GENERAL EXPENSE            45
SALARY                              98
CULTURAL                         15
KITCHEN                            149

The listing

RENT                                  
GENERAL EXPENSE            
SALARY                              
CULTURAL                         
KITCHEN

does not have to follow any particular order - as long as it adds up, that is cool.

Please do let me know if you need extra details to get work done.

Thanks in advance.

 

[kelly mort]

Cross posted at :

How To Add Or Sum Up Data For A Given Month (Selected In A Combobox) With VBA Code

Cross posted at : https://www.mrexcel.com/board/threads/how-to-add-or-sum-up-data-for-a-given-month-selected-in-a-combobox-with-vba-code.1160006/ Reason: I have not received any solution yet. I will want the summed data to be displayed onto another sheet, sheet2. And should look like...

www.excelforum.com

Reason:
I have not received any solution yet.