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 attachment.


hope will get the solution from here.

thanks,

ryan