Macro to count based on date and quota

Status
Not open for further replies.

CpKGuelph

New Member
Joined
Mar 19, 2013
Messages
27
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.

1653669370556.png


"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!
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
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.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,223,888
Messages
6,175,217
Members
452,619
Latest member
Shiv1198

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top