Hi nathansav,My problem is different. Actually in the attached workbook, in sheet1 there are policy numbers present so we have to start from row 2 to the last used row and check if the policy number in column A of each row is present in Access table(Polno). If yes then in access table , there are fields scandate and batchno of each polno so the code should copy scandate and batchno in the corresponding cells in the excelsheet. There are actually sheet1 to sheet5 that contains data so the code should look for all the policy numbers in all the sheets and the update them with corresponding scandate and batchno.

Many Thanks