Hi I'm new to the forum, hope I put this I the right place!

I need some help with a small excel project I'm working on and was hoping some of you could help me on my way!

The project I'm working on is for checking the measured Valve clearances on 4 cylinder motorbikes
They have 16 valves in all and I had made a spread sheet which has cells to enter the Min and Max Valve clearances for 8 exhaust and 8 Inlet valves they have different tolerances.

I have been able to do this part so I am at the point where once the valve gap min and max are entered for the exhaust and inlet valves on Cylinder 1 this changes all the min max gaps for all the other inlet and exhaust valves.

And once I have measured the gaps and entered the actual valve gap the sheet then tells me if the measured value is in or outside the valve clearance tolerance. And this is all working very well!

Now the part I'm having the trouble with.
To save money on buying new shims which is what is used to adjust the valve clearance I swap as many shims that are out of spec on the inlet side to the Exhaust side and vice verse that will bring the valve back into spec.

Once a shim is found out of spec it must be removed, it's measured and that measurement is entered into the sheet and the sheet then tells me what size shim to replace it with to bring the valve gap back to as close to the centre of the tolerance as possible.
What I won't the sheet to do that I can't work out how is once all the out of spec shims have been entered I want it to check and tell me which shims can be moved to which valves to bring them back in spec! All valves are numbered from 1 to 16 and cylinder number exhaust and inlet valves.

Can anyone help me with this

Sorry for such a long 1st post but I wanted you to understands where I and and what I am trying to do!

Cheers and thanks in advance for any help!