Need help on VBA code..

[yameixtz]

Hi there. I was wondering if you could help me on this. I'm not good on Macros.

I wanted to group the data from SHEET2 by OFFICES (Column E) so I will be able to sum up their ACTUAL LITERS WITHDRAWN (Column K) per office. Once total liters is summed up by office.. 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 (Column D). Then automatically it will deduct from (Column C) ALLOCATED LITERS and output on (Column E) under BALANCE LITERS.

I attached my test excel file for you to get a glimpse on.

It would mean a lot if you could help me on this guys. Hope to hear from you soon. Thank you. Keep safe everyone.

 

[maabadi]

I edit your file, you can see it.
Also you should change all 23 at your formula to last row of your source data at Sheet2.

 

[yameixtz]

I edit your file, you can see it.
Also you should change all 23 at your formula to last row of your source data at Sheet2.

why do the office CTO got 30 LITERS WITHDRAWN in Sheet1 when it has inly 20 ACTUAL LITERS WITHDRAWN from Sheet2?

 

[maabadi]

I forgot to fix second part of formula, check again file.

 

[yameixtz]

I forgot to fix second part of formula, check again file.

I think my problem is solved. Thank you so much for your help maabadi. Keep safe.

 

[maabadi]

You're Welcome & Thanks for follow-up.