Hi

I have an excel sheet, which has two columns ( for eg), both Col A and Col B contains data which is already available in a MySQL database.

Col A, I will fill-in , but I want Col B to be auto updated with the corresponding value available in MYSQL database. The col B value in database keeps changing unlike col A which is always constant once created.

I have more than 500 entires, and it becomed difficult to manage the col B for all these entries as it is ever changing.

Pls help me out in getting this accomplished. I am a basic user of excel.

Thanks
Hari