Macro to sum and paste the data based on date

[Villalobos]

Hello Experts,

I am a new in VBA and I would like to ask some help how shoud I do that if would like to summarize and paste the data based on date criteria. I am looking for a solution, I am not a business professional but I have to do it and it seems difficult for me. I uploaded the sample file.

Thank you!

[event21]

Hi -

Hopefully you can start with this approach.

Please Login or Register  to view this content.

event

[venkatpvc]

another way
in sheet i have insert a commandbutton just click on commandbutton job will done.

Please Login or Register  to view this content.

[Villalobos]

Hi Guys,

Thank you the advice.

@event21
I would like to see only that values are which higher than 0 (it means that I want to exclude G0 from the list). How is it possible?

[Villalobos]

Hello Again,

I did not found that way which could be exclude the 0 values during the summarizing, but I figured out a way how delete that rows which has 0 value:

Please Login or Register  to view this content.

[Villalobos]

ohh... I have missid the first line

Please Login or Register  to view this content.