Where in Tutorials

[kwelch]

Can I find direction to do the following?

I have two sheets in Excel. Sheet 2 holds a ton of data (names). In Sheet 1, I want to be able to start typing a name, and have the info from sheet 2 populate and complete what I am typing.

Since there will be several names, as I type I want excel to whittling down the choices. If this is not possible, I will even take a drop down menu that allows me to select info from sheet two, to populate fields in sheet 1.

I appreciate any help. I don't know where to even look in tutorials to describe what I want.

Thanks