I have a workbook that is used to keep track of hub mileage (in column B) and hours ran (in column C) of trailers. A new sheet is added weekly to record that weeks data.
I am trying to come up with a macro that will compare only the previous weeks data and throw up an alert if the mileage gap is greater than
2500 and hours gap is greater than 150. Can anyone help with this?