Cars Log

nf24eg

Board Regular
Joined
Nov 15, 2009
Messages
148
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
Hello, I handle the follow up of about 350 cars for their maintenance and accidents.
I try to make an excel file that will have a sheet for each car that includes it's details (Model, Type, Year, Insurance, Driver name, etc ... ) , accident history by dates, description, fees and the status
on the other hand, I would like to have a report (sheet) that shows all together.

what I made :
index sheet includes all cars numbers that have accidents, using a VBA code that whenever I create a new sheet (by can number) it automatically record in the Index
then I have no more ideas how to continue record the data to get the report
P.S: I tried Pivot table consolidate but it's not practical to choose data from 200 sheet one by one ... any ideas ?
Thank you in advance
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
I would have the non changing vehicle details on a single sheet, from VRM, then use that as a lookup, your driver might change so that should be part of a drop down, then the event, RTC, service etc as a drop down, and a column for the date, you could pivot from that reference sheet then
 

nf24eg

Board Regular
Joined
Nov 15, 2009
Messages
148
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
do you mean to make a single sheet for each car detail or all cars details in one sheet ?
and regarding recording the accidents (should be by date), will in separate sheet for each car or how ?
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
all cars on one sheet as that never changes, and you could put a million there

the collisions, could be by VRM on a single sheet, unless you are wanting pages of information that could be used to review a paper file or even better something held in onenote
 

nf24eg

Board Regular
Joined
Nov 15, 2009
Messages
148
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
will try this idea :) and then feedback
thank you
 

Watch MrExcel Video

Forum statistics

Threads
1,118,814
Messages
5,574,486
Members
412,597
Latest member
Timtec
Top