Userform to scan P.I.G. data and rank cells 1 to 4

[group10]

Basically I have two sets of readings for a pipeline scanner on one table. The first readings end at column Q. The userform created for the data needs to scan the data and highlight cells of error if the number is over a certain value. The userform then needs to rank these cells of error on a 1-4 scale. 1 being a single highlighted cell that doesn't have its coordinating cell on the other table highlighted. 2 being a series of highlighted cells in one column that also doesn't coordinate to the other table. 3 being a single highlight that also coordinates with the other table. Finally, 4 being a series of highlights that also coordinates to a series on the other table. So far, I have been able to make my userform scan the data and highlight cells of error with a red highlight. I still need my code to identify the cells based on either the highlight or its value of error and place it on 1 of 4 other sheets depending on if the error is rank 1,2,3 or 4. I have attached the data below with the highlighted cells and my current userform. Any help would be greatly appreciated!

-Josh

[tehneXus]

Hi,

try this, please note that the row numbers entered by the user a not absolute rows and columns but data rows, e.g. the user enters 1 for 0mm, there are constants in the code which define the absolute beginning of the data: P.I.G. data TESTING.xlsm

Regards