VBA code to sum cells between two dates

[Audit214]

Help!!!

I rebuilt a transaction history for +-50 000 records using formulas and now my analysis has moved to determining whether money was received between two specified dates for each record.

The transaction history has a unique reference for each record in column A and the dates for each month (Nov 2019 to August 2021) are in row 1. I have been struggling to write a formula to sum the amounts between these dates because of the way the date is organized. My next idea is to try to use a macro to select the cells between the two dates and sum these cells for each record.

Does anyone have an idea on how I can do this with vba.

 

[alansidman]

It would be very helpful if you supplied a small sample of data which represented what you have and then what you need. Use XL2BB so that we can manipulate the data. Pictures are not a good idea as the data is not manipulative.