Sheet 3 of my workbook is a tracking sheet. In cell B8 (sheet 3) I enter the
amount of time's that I've made an entry of time on sheet 2. The times I
enter on sheet 2 are used to track vehicles that are passing a set location.
On sheet 2 I enter the times in column D. The vehicle's I count have numbers
to ID them in column F.
The numbers look like 401N1501, 401N1514, 401S1516, 401S1600. The part of
the number I need to associate with my count is the first four digits, 401N,
401S.
Is it possible to do this?