Hello,
I need help automating this.
What I want to do is simply display the cash outflow amounts per vendor on a monthly basis.
Example: In Jun 20 (Column C) the amount owed to the Vendor: Builder (Cell A3) is 314.914,85. This number would come from Amount (Column L) in the ‘Entries’ tab by referring to Month:Jun 20 (from Column A) Vendor:Builder (Column F )and Cost Group: 300 (Column H).
So something like If it is August 20 Look for Entries of August 20 in the Entries tab then match the vendor and the cost group and display the corresponding amount in the cashflow tab
I’m quite new to VBA and am getting nowhere.
Thank you so much for your help.
Bookmarks