I need a macro to assign to a button to track transferred quotes. I need this macro to reference today's date against a column's date cell, to add +1 to the corresponding count, up to a limit set in another cell.
"TRANSFER" button is meant to add a tally to date column based on today's date, up to the quota.
So I would need the macro to reference B106-F106 against J105, and if it matches, add +1 to row 108 in the corresponding cell. (IE Only on May 30 button would add +1 to B108, etc)
Then I would also need to reference 108 against 107 to allow tally only up to the quota.
I had this formula before, but needed a button for each day:
If Range("B108") < Range("B107") Then
Range("B108") = Range("B108") + 1
End If
So I would need that function included as well, but with the same date formula.
Any and all help is greatly appreciated!!! Thank you in advance!
"TRANSFER" button is meant to add a tally to date column based on today's date, up to the quota.
So I would need the macro to reference B106-F106 against J105, and if it matches, add +1 to row 108 in the corresponding cell. (IE Only on May 30 button would add +1 to B108, etc)
Then I would also need to reference 108 against 107 to allow tally only up to the quota.
I had this formula before, but needed a button for each day:
If Range("B108") < Range("B107") Then
Range("B108") = Range("B108") + 1
End If
So I would need that function included as well, but with the same date formula.
Any and all help is greatly appreciated!!! Thank you in advance!