Hi Kenneth, thank you. Everything worked except when I divide- it didn't work. I need to divide the respective columns of the sums obtained for each column in Hello1 by the same columns that were summed in Hello. So from C7: DF7 - it would have the values of the sum of Hello1 / sum of Hello columns.

Kenneth Hobs

08-01-2019, 12:41 PM

I think you meant C7:F7 in #3. I did not code it for jagged ranges. As such, it could go something like:

Sub Main()
Dim ws As Worksheet, rH As Range, rH1 As Range, col As Range
Dim c As Range, i As Integer, a