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

Many of our users are reluctant to download files from sites not connected to Excel Forum. We prefer that you upload your file to this site.


Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here is code to eliminate the Km. For the other values, ie. Liters, etc. Just substitute in new code. I am not sure what you mean for the rest of your requirements. Please clarify with specific examples as your explanation is unclear.

Please Login or Register  to view this content.

Here's the additon to remove the +500 values. I don't have a solution for you for adding the items as you don't have a normalized data sheet.

Please Login or Register  to view this content.