I am trying get totals from combined worksheet and show the results on the summary Worksheet

  • im trying to get totals from combined worksheet and show the results on the summary sheet using VBA. It needs to be VBA for the assessment meaning I cant use sum/sumIf. I have done some code but it all appears as 0 on the summary Worksheet. I'm not sure exactly what I'm getting wrong whether its the range name or some else


    the totals part of the vba code. I will also include the full code below. i am also open to a different approach if you think that may be easier/better.


    Full code. Any help is much appreciated.


  • Your sample workbook does not include Roles that match your request. To assure a workable solution your data must be representable or your actual data and needs. For what it is worth, I would do this with Power Query.

  • With numerical values, something like this should work.

    This is just an example as you should notice.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!