Cross posted at :
https://www.mrexcel.com/board/thread...-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 second image.
The original data is on sheet1 and looks like the first image.
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:
While 28-01-21 might have:
So let say the month of January has only these two dates in my database, then I want to display on the sheet2 this:
The listing
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.
Bookmarks