Posts by yameixtz

    Macro or a Formula it won't matter as long as I get my desired output and automatically. Like every time an office data is added to Sheet2.. Sheet1 will automatically be updated of the office's BALANCED LITERS.

    Yes the data is coming from Sheet2.. and it will be adding data from time to time since offices will be using fuel in liters and will be recorded. And I am hoping every time a data is added or an office is using fuel in liters and is recorded in SHEET2.. it will automatically be deducted on the summary SHEET1 per office. Each office has its own ALLOCATED LITERS.

    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. :)

    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