Particular Range each column wise sum & match with Total in last row

[Marc L]

I tried but not do this can u pls tell me how to do this

Already done since post #9 …

As I yet wrote, you just have to think about what must be done
• before loop
• inside loop
• after loop …​

         Dim Ws As Worksheet

'   here stuff before loop

    For Each Ws In WhichWorkbook.Worksheets
'       here stuff inside loop
     Next

'   here stuff after loop