auto populate names in another sheet in excel 2010

S

steve400243

New member
Joined
Sep 28, 2016
Messages
6
Reaction score
0
Points
0
Hello, I need some help on this.

I have a large list of names on sheet2 - RowC. when i start typing the names on sheet1 in rowA, is there a formula or such to autofill the names?

Thanks so much for any help.
 
That did not work for me on this particular worksheet. Thank you.
 
Last edited by a moderator:
One workaround is to copy the list into the top of the column where you want to enter the data e.g. column A.
Hide the entire rows containing the list. Now you will be able to auto fill while you type.
Hope this helps.
 
You must log in or register to reply here.
Back
Top