Greetings and thank you for all the help. The code below looks at each row of data and depending on whether there is a 1 or a 0 in column K, I get a popup message that tells me if an item is available or not by comparing one row with another. If an item is not available and the current row as well as the row below is 0, the code has a DoWhile loop that will prevent getting popups everytime an item of the same type is not available. However, I am now trying to get the code to also alert me when there is more than one item unavailable of different types. I would like it to take column B and compare the type of product when column K is 0. If one row is differen from the next in column B that means that the items may be different in type although both may be unavailable. Does any one have any suggestions on how to achieve this?
HTML Code: