newssssss.xlsm

this is my project this is a fuel consumption monitoring

the fill button in the worksheet is used for filling up the platenumber column with above cells

now i will use this to make a pivot table for the platenumber and sum of diesel in next worksheet

next is my biggest problem how do i determine if the plate numbers are over consuming diesel.

this is the car types:

Student car - 50 liters
OB car - 30 liters
Shifter - 40 liters
Mail Car - 45 liters


the file should have registration form of plate numbers' car type so it can compare the platenumbers' sum of deisel against its corresponding limit above.


can you help me please i just need to finish this to pass my subject T_T thanks