Sorry for the late reply, pretty busy lately.
As requested I will do my best to explain the code.
Line 1: Te name of the code.
Line 2: Declaring fRange as range, letting Excel know what we plan to do with the variable fRange (short for find range and can be changed into anything, well almost anything).
Line 4: Selecting sheet1 so that the code can be run from any sheet.
Line 6: Starting the For Each loop within the given range. It starts at row 2 of column A: Range("A2:A"
, while this part: & Range("A" & Rows.Count).End(xlUp).Row)
looks for the last used row.
Line 7: This is where we use Find to find the value in column a in column N. When the value is found fRange becomes that range, otherwise fRange stays nothing.
Line 8: If statement. If fRange is range then continue code. If fRange is nothing continue code from line 12.
Line 9: If statement. If the cell 10 columns to the right of the cell from the loop is the same as the cell 2 column to the left of the cell linked to fRange then continue code. If not continue code from line 11.
Line 13: Go to the next cell in the For Each loop.
Let me know if you can figure it out and keep in mind that you can post your workbook the same way I did (carefull with sensitive data), so we can take a look at it.