how to sum end of month with vba

[Kaanapadhiyar]

i have data for the two month and which i need total through month wise. and sum should derive beside colums of last date.

 

[vletm]

Kaanapadhiyar
You've opened Your thread to Ask an Excel Question with a snapshot.
Your title gives image that You would like to solve it with VBA Macros.
... if so, then this thread should be opened in that forum.
But ... as You've two months data ... Could You use Pivot-table to get Your needed solution.
Or is there reason, why You need to solve this with VBA?

 

[Marc L]

Just using the Sub Total Excel basics feature (Data menu), even under VBA needing a single codeline, so easy with the Macro Recorder !​

​

 

[Kaanapadhiyar]

Rightnow I have but many times been two year also there. So I want go through vba so it become faster. And I m not familiar with pivot table.....

Thnks

 

[pecoflyer]

Rightnow I have but many times been two year also there. So I want go through vba so it become faster. And I m not familiar with pivot table.....

Thnks

Then it is a good moment to learn about PT's ( and structured table reference at the same time) https://www.contextures.com/xlpivot01.html
PT's are much easier to handle than VBA

 

[Marc L]

So I want go through vba so it become faster.

As a sub total VBA procedure is not faster than directly using the Sub Total Excel basics feature …​

​

 

[Kaanapadhiyar]

if any one create code for this really great to me

 

[Marc L]

As your initial post is nothing but a guessing challenge which has no place in any Excel forum,​

as any Excel beginner can activate the Macro Recorder and operate the Excel Sub Total feature for example​

in order to get his own code base …​

​

 

[Marc L]

Or, according to your initial post, fit this Excel basics VBA demonstration to your workbook :​

​

Do you like it ? So thanks to click on bottom right Like !​

​