Hi there. I was wondering if you could help me on this. I'm not good on Macros.
I wanted to group the SHEET2 by OFFICES (Column E) so I will be able to sum up their ACTUAL LITERS WITHDRAWN. Once total liters is summed up.. I will be able to deduct the number of liters actually withdrawn of a certain office from SHEET2 to that summary in SHEET1 under LITERS WITHDRAWN