Create macro on excel generated reports

Hi, excel masters. I don't know much about macros and VBA but I know that this can be done. if someone would be nice to help me, i would be tremendously grateful. Thank you

here's what I want to achieve,

1. I want to eliminate all texts that have "KM", "Litres", "Liters"
2. I want to eliminate all values under route length that is greater than 500
3. I want to have the sum of route length for each device because the current value for each device is not equal to actual sum
4. I want to do all this for every report with different set of data but has the same format

below is the link to the excel file. Thank you in advance




https://www.dropbox.com/s/me1qxkh4yb...20Raw.xls?dl=0