Macro to count based on date and quota

[CpKGuelph]

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!

 

[Joe4]

Duplicate to: Macro Button to Reference Limit and Count

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.