I just noticed that your question was for Mac. I do not have access to Mac, but I used generic VBA code which may work. If it does not work, I suggest you wait a couple of days, and repost your question in a new thread, but mark this question as solved, and put a reference in the new thread to your original thread, so you don't get yelled at by the ExcelForum moderators.
Mac VBA reference: https://www.techonthenet.com/excel/m...editor2011.php
NOTE:
a. Sheet 'Global Cash' had data on row 62. Instead of using 'Last Row' I looked for 'Increase/Decrease'.
b. Your sample shows this week as starting August 2, 2020. Today is August 8, the last day of that week. Just so you realize that a new week starts tomorrow.
Try the following code in the attached modified copy of your Excel file:
To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx
Lewis
Bookmarks