Need a VBA for sorting up the donation given by people multiple times

[nikhil3737]

a list in excel has been prepared having a list of people name giving donation in variable amount in every weeks. the same has been noted date wise but that date is also not uniformly.

I have a list of people name having multiple entries in a particular range of excel and beside that having their donation details as price.
i want a function by name of the people so that it can give how much amount of money(Sum of all the money) he has contributed in the last 3 months.

ATTACHED EXCEL SHEET:
BEFORE: I HAVE LIST OF PEOPLE WHO HAS DONATED SOME AMOUNT REPEATEDLY MULTIPLE TIMES. IN FUTURE THEY WILL BE GIVING.

after: I WANTED THEM TO KNOW CONSOLIDATED AMOUNT GIVEN BY EACH PERSON. IN FUTURE THEY WILL THAT WILL BE AUTOMATICALLY REFLECTED IN THIS SHEET AS A SUM.

[davesexcel]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.