I am currently trying to work with two workbooks. One is where data is gathered where I am wanting to compare row 6 values that are what the values should be and compare this to row 8:23 where data is entered. However, the values can be within a certain tolerance, and I have the tolerances located in another workbook. Below is my code, but it is located in the worksheet object so everytime the worksheet is changed the tolerance table opens. ...