Autofill/ Auto Complete.

[Dgriffith]

Good morning all!

so my question is about auto fill I'm not sure if this is even possible or not, but what i have done was built a basic tracking log for personnel on a job site i am on. basically i open a blank one every day and save as and add new date.
my columns are listed as such across the top

Worker Name Assignment/Role Date: Time Assigned Time Off Assignment Badge# Company Location

what I'm wanting to do is on sheet 2 have a master list of all worker names and as i start typing anywhere in the worker name column id like for it to start trying to autofill or predictive text from the master list. I'm not sure if im even working some of this information correct or not but does anyone understand what my end goal is here? or do i need to try and reword this?

 

[AlphaFrog]

Here's a step-by-step guide with video and example file.
Autocomplete Entries With Excel Drop Down List

 

[Dgriffith]

ok great, i wasnt able to make it work by following the guide i tried it 4 times to make sure i was entering things right but i must have still had some errors in it. but i was able to download the template on there and do some tweaking and editing in the codes to make it fit my needs thanks a ton!