Auto fill out exact matching data for multiple entries from another sheet

Hi,

This is Ryan. I have a sheet that my junior staffs mistakes so much for wrong data input. I have decided to put it in this way that when ever I will write the data in one sheet, exact matching information from another sheet will appear in the specific columns.

Like, I have inserted the information in terms master data sheet. In the summery sheet if I input any vendor name, exact matching information of trade term and payment terms will automatically appear in summery sheet’s “R” and “S” column.

In the summery sheet there is already a vba code inserted for updating the date reason. Please help me to solve the above issue.

This is file is here on the below link

http://www.mediafire.com/download/cr.../HELP_FILE.XLS


hope will get the solution from here.

thanks,

ryan