I have two worksheets in my file. I have a value in sheet1 in cell AN2 that I
need to lookup on sheet2 in column AF. When it finds a match I then need to
change the value in column N on Sheet2 for the row it found the value in. How
can I write vba code to fire this code?