Thank you Old Chippy, ur a life saver...
Please find the link for the sample workbook I have tried to explain what I am exactly trying to achieve.
http://dl.dropbox.com/u/13693408/Sample%20Workbook.xlsx
I am trying to write a macro to compare data from two different tables and write a value in a different cell.
For Example
Would like to compare A1:A900 (Dates) of Table 1 to C1:AB1 (Dates) of Table 2 if true, then compare B1:B900 (Sites) of Table 1 to A1:A900 (Sites) of Table 2. If both...