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]

Welcome to MrExcel Message Board.
1. Please upload example file & Desired Result with description below of my post.
2. you want VBA, What about formula:
For Example if your data start form row 2 at sheet1, then you can write at D2 this formula and Drag it down:

=SUMIFS(Sheet2!$K$2:$K$200,Sheet2!$E$2:$E$200,A2)

 

[yameixtz]

The data on SHEET2 will be adding data from time to time.. and of different offices. See the sample EXCEL file uploaded.. I'm hoping every time a data is added.. and depending from what office.. LITERS WITHDRAWN and BALANCE LITERS will automatically deduct from the ALLOCATED LITERS from SHEET1.

 

[Alex Blakenburg]

@maabadi unless I am misreading it I think we need to throw Fuel Type into the criteria.

Formula for D32.

=SUMIFS(Sheet2!$K$2:$K$1000,Sheet2!$E$2:$E$1000,A32,Sheet2!$I$2:$I1000,B32)

 

[yameixtz]

I'm new here.. Can I upload my EXCEL file here along with my post so you can get a glimpse of it?

 

[maabadi]

Can I upload my EXCEL file here along with my post so you can get a glimpse of it?

Yes. This is my description below of my Post.
please upload example with XL2BB add-in (Preferable) OR upload at free hosting site e.g. GoogleDrive, OneDrive, Dropbox and Insert Link at post.

What about Formula?

 

[yameixtz]

Yes. This is my description below of my Post.
please upload example with XL2BB add-in (Preferable) OR upload at free hosting site e.g. GoogleDrive, OneDrive, Dropbox and Insert Link at post.

What about Formula?

link to my test-file.

TEST-file.xlsx

Sheet1 OFFICE,FUEL TYPE,ALLOCATION (Liters),LITERS WITHDRAWN,BALANCE BUDGET,DIESEL,615,0,615 LCR,DIESEL,363,0,363 CSWD,DIESEL,454,0,454 CTO,DIESEL,340,25,315 VICE MAYOR,DIESEL,1863,0,1863 CHO,DIESEL,580,0,580 PDAO,DIESEL,681,0,681 CIO,DIESEL,726,0,726 COUNCIL SECRETARY,DIESEL,623,0,623 SP ALVAR,...

docs.google.com

 

[yameixtz]

Yes. This is my description below of my Post.
please upload example with XL2BB add-in (Preferable) OR upload at free hosting site e.g. GoogleDrive, OneDrive, Dropbox and Insert Link at post.

What about Formula?

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 Sheet1.. Sheet2 will automatically be updated of the office's BALANCED LITERS.

 

[maabadi]

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 Sheet1.. Sheet2 will automatically be updated of the office's BALANCED LITERS.

Then Use @Alex Blakenburg formula at Post #4 and drag it down.

Also if you can access to me to edit your uploaded file, I can add formula to that.

 

[yameixtz]

Then Use @Alex Blakenburg formula at Post #4 and drag it down.

Also if you can access to me to edit your uploaded file, I can add formula to that.

I have given you access.. I will see you formula. Thank you.