Hello.
I have a GPS fleet tracking program that generates a CSV every month on drivers speeding violations.
I want to track them month to month, however when someone leaves the company, and they are no longer on the chart, it messes with the graph, and "Jim" ends up getting "Johns" speeding stats (when i just select an entire column of data, but i dont what to populate it one by one) Is there a way to make the chart know who "Jim" is from month to month, or sheet to sheet?
That is the best explanation i can give, please feel free to take a look at the chart.
Thanks again.
speeding data km per event1.xlsx
Bookmarks