Thanks Greg M, I ran your code it's almost perfect to what I was looking for, but just few questions. If I have multiple values in column E like 112, 159, 687 etc, how will I list those constants to achieve the same goal you did with just 112? And also it seems that Const iSTART_ROW As Integer = 2 has to be changed to Const iSTART_ROW As Integer = 1 to execute for row 2 is this correct? Thanks again