Hi
I have exported data in excel from a Webpage which contains Colmns A to GG and Rows below.There is data in the corresponding colmns which is modified in the Exported sheet. I want to lookup the same data in the Excel sheet column A and change the data present in Col B to GG.
Example:

Excel :

A B C D
1 100-1 23 65 43 7
2 200-2 45 34 56 3
3 300-1 12 32 4 32

In the Webpage:
The same table only Colmn A is constant but the other Coulmns vary which have to be changed.

How do i use a VBA to match item in cel A1 in the excel sheet , search for the same item in the web table and then copy the value from B1 in the excel sheet and paste it in corresponding table cell in the Web table.
I have tried to be as clear as possible,Please let me know if more clarity on the issue is required
I would really appreciate if someone could help me with the Excel VBA codes for the same.
Thanks Much,

Navneet