S
salgud
to do this without going to VBA?
I track the Division vehicle for our group. Every 5,000 miles it needs an
oil change. I have a spreadsheet to track the mileage which I enter every
month near the end of the month.
Date Mileage Status
7/30/09 10,000 oil change
8/29/09 11,200
9/28/09 13,300
10/30/09 15,001
I'm trying to figure out if there is a way using a formula to tell me when
the difference between the latest mileage entry and the last oil change
mileage is greater than 5,000 miles, as it is in my example on 10/30.
(10/30 mileage is 15,001, last oil change was at 10,000). Or is this a job
for some VBA code?
I can write the code, just have it activated whenever a new mileage entry
is made and have it calculate the difference between the new mileage and
the previous oil change mileage and give me a Msgbox telling me when an oil
change is due. But I am wondering is it can be done with a formula. Not
sure how to tell it to find "oil change", or even the previous text entry
in that column, then do the calculation from that inside an if statement
having a message if the difference exceeds the 5,000. Anyone know how to do
this, or even if it's doable?
Thanks in advance.
I track the Division vehicle for our group. Every 5,000 miles it needs an
oil change. I have a spreadsheet to track the mileage which I enter every
month near the end of the month.
Date Mileage Status
7/30/09 10,000 oil change
8/29/09 11,200
9/28/09 13,300
10/30/09 15,001
I'm trying to figure out if there is a way using a formula to tell me when
the difference between the latest mileage entry and the last oil change
mileage is greater than 5,000 miles, as it is in my example on 10/30.
(10/30 mileage is 15,001, last oil change was at 10,000). Or is this a job
for some VBA code?
I can write the code, just have it activated whenever a new mileage entry
is made and have it calculate the difference between the new mileage and
the previous oil change mileage and give me a Msgbox telling me when an oil
change is due. But I am wondering is it can be done with a formula. Not
sure how to tell it to find "oil change", or even the previous text entry
in that column, then do the calculation from that inside an if statement
having a message if the difference exceeds the 5,000. Anyone know how to do
this, or even if it's doable?
Thanks in advance.