The attached document has the problem. I have several problems with this spreadsheet and the VBA I'm building into it, but I hope with this one question answered I may continue. In the sheet JAN I have Button 8 and a macro it runs. The macro of this button should loop through every row in the Alex column and sum each heading (Hours, CC pledges, CC amounts, etc. through Not Home) to its place in the first 12 rows for Alex. It works for the first header (Hours) but then doesn't work for any of the other header types - it gets caught looping infinitely.
Call Report.xlsm
Bookmarks