Hi all,
Good day.
Referring to the attached sample, I would like to populate the data from my raw using macro.
Reason being, as my raw gets bigger (currently ~78k rows), it took some time to refresh everytime the users change the value from drop down. Also, the file size is quite big for email distribution.
A senior of mine suggested me to use macro to do all the calculation directly from the raw instead of using formula and pivot.
My intended result is :
1) to show the sum of duration, of each segment, for each month, base on the name from drop down.
2) to show the sum of duration, of each group, for each month, base on the name from drop down - group 1 = segment 1&2, group 2= segment 3&4, group = segment 5
all calculated directly from raw without adding any helper column, like =month (I colored as yellow in my sample file)
So far, I can understand the part of calculation using nested for each loop for the multiple criteria. My main obstacle is that I don't know how to populate the data to the table as I am only used to using formula to populate data.
Hope my explanation is clear.
Appreciate any assistance.
Thank you!!!
Bookmarks