How about this...

Use drop down lists on sheet2 then you don't have to do any typing at all,
you can just select the name from the list.

Watch this 5 minute video:

http://youtube.com/watch?v=t2OsWJijrOM

--
Biff
Microsoft Excel MVP


"stremetzky" wrote in message
...
Hi,
I have Sheet1 with different names in a column.
In the Sheet2 I have to type in the names in certain cells. What can I
do that I don't need to write the whole name again but after I beggin
typing excel would check the list of names in Sheet1 and help me to
autocomplete it.

Thank you for your suggestions,
stremetzky