Hi all,
I'm trying to find a way to have a time and date stamp when I reconcile my transactions each month (currently set up to stamp when I click Reconcile button), but need it to stay static to the month of the reconciliation. The reconciliation is tied to a drop down in J1. In other words, when I select the reconciliation month in J1, I need time and date that it was reconciled to populate. Also, I'd like the checkmark and Recon ID in the transactions tab to lock once the Reconciliation button has been clicked. Here's what I currently have:
Transactions Tab:
Reconciliation Tab:
Pulls transactions from Transactions Tab based on pull down selection in J1 using =FILTER(Transactions!$A$3:$G$1048576,Transactions!$I$3:$I$1048576=Reconciliation!J1,"") in cell A3.
Cleared Checks (J10) counts the number of items using formula =SUMPRODUCT(SUBTOTAL(2,OFFSET(G3,ROW(G3:G80)-ROW(G3),0,1)),--(G3:G80>0)). Same used for Cleared Deposits.
Reconciliation Date time stamp is created when you click Reconcile using VBA
I hope I've provided enough information. Please let me know if you need more. I'm still in the beginner world with VBA, so I'm sure there's more I could be doing. Thank you in advance for your help!
I'm trying to find a way to have a time and date stamp when I reconcile my transactions each month (currently set up to stamp when I click Reconcile button), but need it to stay static to the month of the reconciliation. The reconciliation is tied to a drop down in J1. In other words, when I select the reconciliation month in J1, I need time and date that it was reconciled to populate. Also, I'd like the checkmark and Recon ID in the transactions tab to lock once the Reconciliation button has been clicked. Here's what I currently have:
Transactions Tab:
Reconciliation Tab:
Pulls transactions from Transactions Tab based on pull down selection in J1 using =FILTER(Transactions!$A$3:$G$1048576,Transactions!$I$3:$I$1048576=Reconciliation!J1,"") in cell A3.
Cleared Checks (J10) counts the number of items using formula =SUMPRODUCT(SUBTOTAL(2,OFFSET(G3,ROW(G3:G80)-ROW(G3),0,1)),--(G3:G80>0)). Same used for Cleared Deposits.
Reconciliation Date time stamp is created when you click Reconcile using VBA
I hope I've provided enough information. Please let me know if you need more. I'm still in the beginner world with VBA, so I'm sure there's more I could be doing. Thank you in advance for your help!
