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
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