Forum Discussion

S_Buddell's avatar
S_Buddell
Copper Contributor
Jun 17, 2021

Data grab from Debrief sheet

Hey Guys,

 

I'm on a Microsoft pc running the current Microsoft Office.

I'm a basic user on Excel, but quite good, I think.

My issue may sound complex, but that will be because I am not aware of the correct formula, or even how to use it.

We have several vehicles delivering goods, I have a simple sheet with various simple formulas for MPG and Total miles. What I'd like is to be able to see a 'running total' of each vehicle on a different tab.

E,G.

I enter AB12CDE as a vehicle and it's miles in/out and fuel, get an MPG on the first sheet, but I want to be able to use a formula to search sheet 1 for the vehicle, and then get the required info (miles, MPG & so on) o to a new sheet, but grouped by vehicle and info.

Does that make sense?

 

Sheet one input data, Sheet 2 extrapolate that data and display in simple form as a running total.

 

Much head scratching, any hints, tips, or help will be appreciated.

 

Steve Buddell

excel
Formulas and Functions
training

3 Replies

  • S_Buddell's avatar
    S_Buddell
    Copper Contributor
    Jun 21, 2021

    S_Buddell 

    Hi Guys,

     

    Sorry for the delay in replying, i have a day's leave(for my second Covid Jab) and then it was the weekend.

    Thanks 

     

    input various data in the cells above (first sheet), some with basic formulas (divide or subtract).

    Then display a ‘running total’ on the data tab (second sheet). In the required vehicle ID cells.

    My aim is to have the data sheet display fuel, AdBlu, MPG, and cost, then I add the required info on the Planner sheet, but have it displayed in the correct cells on the Data sheet.

     

    I have attached the file.

     

    Thanks in advance.

     

    Steve

Resources