Fleet tire depth tracker

[aachoudh]

Hi guys

I am in the need of tracking tires depths in my fleet, i want to be able to put data in another sheet of all 6 tires on the trucks, and then it be updated on another sheet, i also need a conditional formatting for when the depths reach 4.

Truck#	FR	FL	RR	RL	RRR	RRL	Date Inspected	Date Replace
1	11	11	11	11	11	11
2	22	22	22	22	22	22
3	12	12	12	12	12	12
4
5
6

<tbody>
</tbody>

As you can see here i want my data to be placed like this on the main sheet that everyone can access, i need for it to pull data from another sheet in the same work book, and i need it to change yellow on the main sheet when the depth goes to 4, Please help me create all this. Also i want this main sheet to keep updating and automatically adding a line everytime i put in a new update from the other sheet. Please help

 

[peterhinton]

try using a pivot, then looking for some code that will update the pivot each time you add a new line

 

[aachoudh]

Im having trouble all around building this sheet, my pivots arent working, im trying different formulas/codes its not working, please help me build this sheet.