This question is building off the elegant solution provided by Alan found in my previous post.
I was trying to modify his code as my excel spreadsheet expanded to:
2021-04-19_16-41-33.png
How to automatically get the sub-totals from each blocks (shown in P11-P13, AB11-AB13, P19-P21 and AB19-AB21) then get the overall total to show up in Column E.
The original VBA code written by Alan is:
Please note that I have also cross-posted this question on Mr. Excel but due to my limited posts on this forum I cannot attach the actual link. The post on Mr. Excel is #post-5678201Please Login or Register to view this content.
https://www.mrexcel.com/board/thread.../#post-5678201
Bookmarks