Well problem is relatively simple.
We have a few (230)Cars that are sometimes are working and sometimes do not. my job is to record how many days each car worked. So i need excel macro code that will record car VIN Number(car number) and time it was places on a road/ or removed.
But there is a small problem i also need some kind of check that will not allow me to place same vehicle on road if it is already recoded On road. Please help ! i tried to use =NOW function but it does not record properly and mixes data when i create report base on the VIN #.

I would greatly appreciate your help by helping me to write this code or at least pointing me in the right direction.


I think it should have 2 buttons one that says on 2nd off.

and on the Sheet 2


ON OFF
VIN Time Vin TIME (so i can subtract on time from off to get total days)


Thank you guy any help will be appreciated.