Data grab from Debrief sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2457383%22%20slang%3D%22en-US%22%3EData%20grab%20from%20Debrief%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2457383%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20on%20a%20Microsoft%20pc%20running%20the%20current%20Microsoft%20Office.%3C%2FP%3E%3CP%3EI'm%20a%20basic%20user%20on%20Excel%2C%20but%20quite%20good%2C%20I%20think.%3C%2FP%3E%3CP%3EMy%20issue%20may%20sound%20complex%2C%20but%20that%20will%20be%20because%20I%20am%20not%20aware%20of%20the%20correct%20formula%2C%20or%20even%20how%20to%20use%20it.%3C%2FP%3E%3CP%3EWe%20have%20several%20vehicles%20delivering%20goods%2C%20I%20have%20a%20simple%20sheet%20with%20various%20simple%20formulas%20for%20MPG%20and%20Total%20miles.%20What%20I'd%20like%20is%20to%20be%20able%20to%20see%20a%20'running%20total'%20of%20each%20vehicle%20on%20a%20different%20tab.%3C%2FP%3E%3CP%3EE%2CG.%3C%2FP%3E%3CP%3EI%20enter%20AB12CDE%20as%20a%20vehicle%20and%20it's%20miles%20in%2Fout%20and%20fuel%2C%20get%20an%20MPG%20on%20the%20first%20sheet%2C%20but%20I%20want%20to%20be%20able%20to%20use%20a%20formula%20to%20search%20sheet%201%20for%20the%20vehicle%2C%20and%20then%20get%20the%20required%20info%20(miles%2C%20MPG%20%26amp%3B%20so%20on)%20o%20to%20a%20new%20sheet%2C%20but%20grouped%20by%20vehicle%20and%20info.%3C%2FP%3E%3CP%3EDoes%20that%20make%20sense%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet%20one%20input%20data%2C%20Sheet%202%20extrapolate%20that%20data%20and%20display%20in%20simple%20form%20as%20a%20running%20total.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMuch%20head%20scratching%2C%20any%20hints%2C%20tips%2C%20or%20help%20will%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESteve%20Buddell%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2457383%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2460640%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20grab%20from%20Debrief%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2460640%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EWe%20will%20need%20an%20example%20sheet%20for%20this%20one%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2465156%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20grab%20from%20Debrief%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2465156%22%20slang%3D%22en-US%22%3Edo%20you%20have%20a%20screenshot%20of%20your%20sheet1%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2465801%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20grab%20from%20Debrief%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2465801%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1081227%22%20target%3D%22_blank%22%3E%40S_Buddell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20for%20the%20delay%20in%20replying%2C%20i%20have%20a%20day's%20leave(for%20my%20second%20Covid%20Jab)%20and%20then%20it%20was%20the%20weekend.%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S_Buddell_0-1624263487003.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F290234i4FDC779EFF1F2D3F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S_Buddell_0-1624263487003.png%22%20alt%3D%22S_Buddell_0-1624263487003.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S_Buddell_1-1624263487015.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F290235i22A73A9734F36762%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S_Buddell_1-1624263487015.png%22%20alt%3D%22S_Buddell_1-1624263487015.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Einput%20various%20data%20in%20the%20cells%20above%20(first%20sheet)%2C%20some%20with%20basic%20formulas%20(divide%20or%20subtract).%3C%2FP%3E%3CP%3EThen%20display%20a%20%E2%80%98running%20total%E2%80%99%20on%20the%20data%20tab%20(second%20sheet).%20In%20the%20required%20vehicle%20ID%20cells.%3C%2FP%3E%3CP%3EMy%20aim%20is%20to%20have%20the%20data%20sheet%20display%20fuel%2C%20AdBlu%2C%20MPG%2C%20and%20cost%2C%20then%20I%20add%20the%20required%20info%20on%20the%20Planner%20sheet%2C%20but%20have%20it%20displayed%20in%20the%20correct%20cells%20on%20the%20Data%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESteve%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies
Hi,

We will need an example sheet for this one
do you have a screenshot of your sheet1?

@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 

S_Buddell_0-1624263487003.png

 

S_Buddell_1-1624263487015.png

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