Hi All
I got stuck in a problem. Please see attached the workbook. There is data present in Sheet1 and Sheet2.I want to check the following things:
1. For each record in Sheet1, If "F" column stores "list work" then don't do anything and move to step 2.
2. Check for each record, If data in "F" column of Sheet1 matches with "H" column data of sheet2 then store the value of corresponding "E" column of sheet2 in "G" column of sheet1.
3. If it doesn't match then leave that record and move to next record of sheet2.
I tried writing the following code but it doesn't work:
Can anyone please help me in this?
Thanks
Bookmarks