I have 1 worksheet with 3 columns: (ID, Name, City) which holds 1000 records.
I have another worksheet with the same columns but are left blank until a
user enters a ID.
What I would like is that when the user enters a ID on the 2nd worksheet,
then it would automatically fill-in the Name and City fields based on the
information from the 1st worksheet.

Thanks.