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.
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.