Summarize Data from Dates to Months based on Criteria

**DocAElstein** · 01-02-2022, 05:19 PM

Hi Siyab,
_1

Originally Posted by msiyab

When new data is entered on the subsequent rows, the values do not refresh on the summary sheet.

Of course they do not. Why should they? You never mentioned anything about wanting the thing to update automatically.
_2 and _3

I am not sure what it is you are wanting or asking.

Possibly two things you need to be considering:
_ Macros do not run by magic when you want them to. You should no that. It’s obvious.
If you want a macro to run when something is done to the worksheet then you need to be considering worksheet event macros as I have done for you before.
_ I already mentioned that I just gave you a macro to give you some ideas. I already mentioned that you need to consider things like making the last row, Lr, dynamic

Your summary in your sample file may be an Excel Table (List Object)? , I am not sure. There may be some efficient ways to deal with Excel tables. I don’t know. I have no experience with Excel tables.

Siyab,
I seriously don’t wish to be impolite or rude, but you have been involved with VBA and excel for 10 years now which is much longer than I have. You may be tackling some diverse subjects, some of which I have no knowledge of.

If you cannot or don’t want to learn , and just want someone to write coding for you then that is perfectly OK. That is your right.
But excelfox.com may not currently be the best forum for you, just now. There are not so many people helping here just now, and I am happy to help, and explain, but don’t have the time to just keep writing macros for you.
Maybe you could try excelforum.com or mrexcel.com. - There are a lot more people there with much more time on there hands and some may be happy to keep just writing macros for you. You will probably get a quicker response there, currently. There are a larger number of helpers there, with a larger range of experience and knowledge of Excel
than those currently at excelfox.com
Maybe later we will have some more people here including some just happy to write any coding for you.
Just now there is mostly only me here and I don’t have so much time for you, sorry.

Alan

P.S: Did you see this?
https://excelfox.com/forum/showthrea...ll=1#post15705