Cars Log

[nf24eg]

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

 

[mole999]

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]

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]

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]

will try this idea and then feedback
thank you