Hello

I'm looking for a VBA that can help me loop through all the worksheets in the workbook and calculate % of grand total in column D starting from row 15 to the last row. I also posted my sample so you can have an idea on what I'm trying to acheive. The expected result is in column E. Thank you all. macro test.xlsx