Trying to sum values in excel sheet based on due date. Goal is to create a macro where user has to press "Command Button" and Macro do the following:
1. Enter a date
2. Check the date against all the dates in Column B (AKA Due Date Column)
- IF the due date is earlier than the date entered, sum the amount due, else, move to the next cell
3. Return the value of the total sum
So far i have this:
Sub ARSUM()
Dim dateEntry As Date
dateEntry = InputBox(“Enter a Date”)
#Selection.Value = status
ARSUM(2).Range(“h3”).value = dateEntry
I know at this point I am going to need some kind of loop. Help?
1. Enter a date
2. Check the date against all the dates in Column B (AKA Due Date Column)
- IF the due date is earlier than the date entered, sum the amount due, else, move to the next cell
3. Return the value of the total sum
So far i have this:
Sub ARSUM()
Dim dateEntry As Date
dateEntry = InputBox(“Enter a Date”)
#Selection.Value = status
ARSUM(2).Range(“h3”).value = dateEntry
I know at this point I am going to need some kind of loop. Help?