Checking in two tables and display the result in Excelsheet.

Hi All

I want VBA code that will perform the following steps. The Table1 has following fields: ScanDate,NewBatchNo,BatchNo,PolicyNo

1. First of all look into Table1 the scandate<=29082014 and then check if there is No NewBatchNo of the corresponding record then capture its corresponding BatchNo of each record whose scandate<=29082014

2.Then check for the batchno that we have captured in another table Table2 and if its present then return corresponding PolicyNo. Now keep on searching that policy no in Table2 as it could be present 50 times in the table and then return corresponding batch numbers in excel sheet of that Policy No as below:

BatchNo - Policy No - Batch No1 - Batch No2 - Batch No3 ---------------

I hope i made it clear. ANy questions please do ask me.

Thanks

Thanks, I have done the 1st step. i.e now sheet 1 contains all the captured Batch numbers in column A whose scandate<=29082014.

Now in sheet1, column A all the Batch nos are present. So now how can I check each batch number if its present in Table2 and then perform rest of the actions.

Thanks

Hi All

Please see attached the Excel workbook. Now in Sheet1 , In column A there are all the Batch nos present from Table1. So I want to write down the VBA code that will Check for Column A batchno in Table2 to make sure if they exist or not. If they exist then find the corresponding policy numbers and store in Column B of the attached workbook. This is step2. Any help would be much appreciated.
Thanks