Sum Data from one Column to Other Column based on Criteria

[nabsher1]

Hi All,

Good Day!

I need your kind assistance to provide me macro which will sum data from one column to other column based criteria. I have attached sample worksheet (SUM DATA)

Data contains daily entries, like Date, Name, Sale And Pay, the VBA code should sum it on monthly bases for each Name as shown in sheet2.

1- When clicking on Command Button in Sheet1,
2- It should sum data from Rage(A:D) in sheet2
3- output should be as shown in columns H:K in sheet2


Note: the solution must be compatible with old excel 2003


Your kind attention and prompt reply would highly be appreciated.

Thank in Advance!

[AliGW]

Please change your forum profile to Excel 2003 if that is what solutions must be compatible with.

[Marc L]

Hi,

where the result must be, in Sheet1 ?

[nabsher1]

Hello Marc,

Thank you for your message.

The Data and result both are in sheet2.

Sheet2 Columns A to D contain data
Sheet2 Columns H to K will be for result / output

Time with date in column A is not important, you can remove it. But it should show monthly sale and pay for each item.

Regards,

[JohnTopley]

Please Login or Register  to view this content.

Results in columns M:P

[nabsher1]

Dear Bro John,

Thank you for your consideration and kind assistance once again.

Your code worked perfectly. Your are such a great help as always!


Have nice day Ahead!

Profound Regards,
Nabsher

[Marc L]

( removed )

[nabsher1]

Thank you too @ Marc L

[sintek]

...Deleted...