VBA to Autofill / autocomplete text in multiple cells of one sheet by querying in another sheet.

[sakkthi]

Sheet2 has rows and rows of Name (A1), City(B1), District (C1), State(D1), Product (E1), PRICE(F1), TAX(G1).

SHEET2 is updated constantly through form data, so rows will increase daily.

In sheet1, start typing name in G8 should fill all details in specified cell if matched and selected (a1-g8, b1-e9, c1-e10, d1-e11, e1-e12, f1-f13, g1-g14) or else leave it for typing.

Thanks for the help.