vehicle

  1. T

    Extracting certain data from a worksheet

    I am trying to figure out the best way to only extract certain data from a download from our rating system. Below is an example of how the data is downloaded from the system VEH 1 - 2000 INTERNATIONAL 4000 4900 STRAIGHT TRUCK {1HTSDAAN7YH256306} City State Territory Stated Amount Cost...
  2. V

    Excel formula to update values for specific columns only

    Hello all, I am looking for an excel formula which would pickup from whole data , here with attached data for your reference. Data available in columns like from Jan to Dec and output i dont want to show everything in one go so only selected months need to be shown in output summary. which...
  3. T

    Gathering information by year

    I have a excel vehicle tracking system that uses log sheets entered by trip that has a date associated with each entry. This includes kilometers driven for that date and for what vehicle. I have the ability to change the year and month on a report tab that will produce the kilometers per vehicle...
  4. A

    Vehicle rotation count

    Hi, I want to know in a day & month a vehicle doing how many trips. Basically rotation of the vehicle. Abbreviation codes: Driver Code GU- Gurdeep G- Gafar G1- It will show the that driver done the multi delivery in this trip. For Example- On 2 June Gafar driver done four trips (G1 to G4)...
  5. D

    Looking for a formula

    Hi, i need a help. I need a formula for the calculation for the below data <tbody> <tbody> Location </tbody> <tbody> Vehicle No. </tbody> <tbody> Transport </tbody> <tbody> Weighment </tbody> <tbody> Charges </tbody> <tbody> Total </tbody> <tbody> Credit...
  6. P

    Vehicle Time Table into Movement Graph - MS Excel

    Good Day, I work in Public Transport planning, we compile our time tables (origin + origin time and destination + destination time on a specific route / path) in Ms. Excel. Once the timetable is completed it looks something like this: https://ibb.co/ccNzSNB You will notice that the...
  7. D

    Returning specific values from another spreadsheet based on criteria.

    I have a spreadsheet where I need to read today's date from it and the corresponding vehicle registrations for today's date into a new spreadsheet in a tidy format. In it I have a series of days in the month, a column with the date in and then another column with the vehicle reg. I need to take...
  8. L

    Fleet Fuel Tracking

    Hi, I'm a first timer out of dark Africa I'm trying to track fuel usage for a small fleet. My issue is how to calculate the distance traveled between dates on a specific vehicle. Any help would be much appreciated. <colgroup><col span="2"><col><col><col><col></colgroup><tbody> Vehicle ID...
  9. F

    Copying rows from one sheet to another sheet based on different input in Column B

    Hello all, I am not a programmer and I am really struggling getting my Excel workbook to do something that has been very simple in google sheets with query formulas. I am currently gathering data daily with a Google Form into a Google Sheet for daily vehicle checks. I am wanting to be able to...
  10. S

    INDEX MATCH with Multiple Criteria and Cannot Select Same Value Twice

    I have a table that looks like the one below with Work Order # in descending order: <tbody> Employee Work Order # Employee Date Worked Employee Name Employee Total Hours Vehicle Work Order # Vehicle Description Vehicle Date Used Vehicle Total Hours Vehicle Operator S11421 9/26/17 Jason 6...
  11. L

    A Way to List Multiple Services Before Code Runs

    Hello, I have this code that will update the appropriate vehicle when the selected service is entered. How it works now is one service is entered at a time. On most occasions it would be better to be able to select multiple services. Does anyone have ideas on how to perhaps have the list of...
  12. C

    Formula needed to receive negative response for multiple columns

    Sorry my Title might be misleading! Here is what I'm looking for. In column D is the date a vehicle is request to be used from in column H is the registration for the vehicle that will be used. I want column m to tell me if that registration input in column H is already in use for the date in...
  13. A

    duplicate userform fields and send to spreadsheet depending on listbox1.listcount

    Firstly, hello to all. I am a newbie here and also a newbie in excel. I need some help from you please. I have been tasked in work to create the spreadsheet with a userform to input all data. On the userform I have a listbox for vehicle numbers. What I need to do is copy all of the data from...
  14. M

    Calendar Help

    I am trying to find out if it is possible to create an auto-populating calendar based on the first Monday of the month, or the third Tuesday of the month, etc. The calendar I need to create is for a vehicle inspection monthly calendar. I have 6 vehicles each day of the month that need to be...
  15. Z

    Highlighting

    Hi! Question.. I have got store list on B3:B7, dates when the vehicle changes for the store on D3:D7, vehicle registrations drop down list on F3:F7 and when the next change is due required on H3:H7.. now what I want to do is if the same vehicle is used for the same store 4 days in a row to be...
  16. Z

    Highlighting dates

    Hi! Question.. I have got store list on B3:B7, dates when the vehicle changes for the store on D3:D7, vehicle registrations drop down list on F3:F7 and when the next change is due required on H3:H7.. now what I want to do is if the same vehicle is used for the same store 4 days in a row to be...
  17. J

    Compare data from 2 columns pull unique rows

    I would like to compare 2 separate columns and list out unique rows in another sheet. Column 1 Column 2 Column 3 Column 4 Column 5 MOW204000235 1 No No Vehicle Maint. MOW204000235 1 Yes No Driver Fitness MOW204000235 1 No Yes...
  18. J

    Missing a quote or got to many extra ones in

    Hi, I am trying to automate some a box on the page. I have a cell with the below =IFERROR(GETPIVOTDATA("[Measures].[Count of c4]",Branches!$B$5,"[Query 1].[Month Name]","[Query 1].[Month Name].&["&$C$7&"]","[Query 1].[Year]","[Query...
  19. A

    Returning multiple HLOOKUP values ignoring blanks?

    Hi all, In A2:A32, I have a list of Toyota vehicle names. In subsequent columns from B:S, I have model years. Each vehicle name does not have the same quantity of model years, some have only 1 other have 11. My question is this: A2 (Camry) has 4 model years (B2: E2) to the right of it. In Z2:Z5...
  20. M

    Data Sorting

    I was just wondering if I could get some help on sorting data. I recently started working at a car dealership for the summer and I'm having trouble finding the right vehicle trim levels for customers based on the features that they want. What would be the best way to do this in excel? In the...

Some videos you may like

This Week's Hot Topics

Top