Ok, I'm working on a spreadsheet for my security department. On the spreadsheet, we enter our beginning mileage and ending mileage when we drive the company vehicles. If they need gas, we have to refuel them and document this on the spreadsheet. However, we only refuel them about once every two days. So my question is. . .
How do I put a formula in to create a list of ONLY the times we refuel the vehicles?
I have multiple sheets in 1 file. One of those sheets is ONLY for refueling information. I want to find a way for it to automatically update the different sheets when I enter the refuel information on the mileage sheet.
Any help would be appriciated!!!
2007-08-27
12:53:22
·
6 answers
·
asked by
Raven
2
in
Computers & Internet
➔ Software
Alright, I'm going to try to clarify my question.
My first sheet has beginning miles, ending miles, refuel mileage, gallons, etc...
My second sheet, is only refuel mileage, gallons, total, etc. . .
I want a way to put the info from sheet one INTO my refuel sheet (sheet 2), however sheet one has MANY entries when someone drives without refueling.
So I need to take only the entries when someone refueld and THEN get them to copy to sheet 2.
2007-08-27
13:26:53 ·
update #1