In the attached:
The macro blah works on the active sheet.
DO NOT RUN IT while the Reference sheet is the active sheet; it will cock things up badly. There's rudimentary code to try and prevent it running on that sheet.

Reference sheet. Make careful note of the comments in it. Note also the lowest threshold in each mini-table; you might want to alter them later.

Xander sheet. You may want to try running blah while it's the active sheet.

Roxie - End Result sheet. Left as you left it, can update by clicking the button on that sheet.

Xander (2) sheet. Two buttons, one just runs blah on that sheet. The other runs through some values. It puts those values in the cells then runs blah once each time. It will allow you to do some testing. Instructions on the button itself.


Cells which are empty have their colour and comment removed.
Cells containing a value outside the possible ranges are coloured blue and a comment added to that effect.

Attached Files

msofficeforums39829Cat results.xlsm (42.1 KB, 10 views)