comparing rows and columns name

Hi all,

I am new to the VBA.I need to help form u ppl.Please find tha attched example workbook.In that i have table 1 and table 2.I need to fill tha values in the table-2 based on the value in the table-1. How do we do that in macro?