Need Help with this problem i dont know if its VBA or formulas any help would be great

New Contributor

I'm working on this spreadsheet and in order to get it to do what I want I need to count the number of times a cell has changed. Problem is I have 54 Assets and 298 total variables. its outlined by a table that has Tires - Rims - Truck # - Truck Asset Tag - Trailer # - Trailer Asset tag - Yard - Yard Asset Tag. Each asset tag is assigned to a particular spot on the truck/trailer, I need it to be able to associate the tire position with the assigned asset tag, then count the changes that occur in the "Tires" section associated with that asset tag and then be able to make a "heat map" I have a picture of a truck and trailer and i want it to assign numbers to the side of the pictures for each location as to which tires get changed the most on what side and such.

 

Any help would be appreciated with this. I've tried VBA coding but i can't figure out how to do it for 298 variables and then output to different areas. I can provide the sheet if needed, I don't know how I can show ya'll any other way though.

1 Reply
instead of having a fixed layout where you change the values at each location you should consider creating a running LOG file and you can have columns be like DATE, LOCATION, ID, ...
Then you can have another page showing the most recent value for each location as a visual 'report' of the present state and then you can also easily tally the # of entries for particular locations, the times between changes, etc...