Auto Populate Text in row

Hi,

Seeking help for some VBA Codes.

I have a template wherein the user will input information in Sheet1 and I have a data validation list in column G starting from row 12.
I actually did this by creating a vlookup formula for each row but it makes the file bigger so I thought of using macro but I am having a hard time putting this into codes.

When I select a list in column G from any row starting in row12, I want column H on the same row to auto populate the description.

The database list can be found in Sheet2.

I have attached the file for reference.

Thank you.

Thanks so much! now it worked..

hi again..

would it be possible that if the user pasted a list in column G it will automatically recalculate the rest of the data?

I did try but only the first data in the list was updated. All others would need to manually select it one by one.

This is okay if not possible.

Thank you.

Thank you. Now it works perfectly fine.