Hi all,

I need help with an excel VBA macro. Basically I have a workbook with two worksheets. I need to write a macro that will search Sheet1 ColumnC for each of the values in Sheet2 ColumnA and, when found, populate the corresponding cell in Sheet1 ColumnE with a value of "Late". I know that VLOOKUP is probably the way to go but I just can't seem to work out the Loop. Any help would be greatly appreciated.

Hi

You can use the Find Method of Excel and achieve the same. Please have a look at http://vbadud.blogspot.com/2007/10/e...ll-method.html

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)