Search box that allows you to start typing and it will autofill the answer matching file names

[dpaton05]

I have a spreadsheet that I want to have something that allows me to start typing a name and it will auto fill as I type to match the name typed with the names on other spreadsheets that are kept in a folder called Young People that is within the folder of the spreadsheet. I am not sure how to do this, could someone give me some guidance please?

After enough letters are typed in and the correct name appears, I want to be able to press a button and have the relevant document open.

Thanks

 

[Michael M]

How many names do you have ??
I'd suggest a Data Validation list
Have a look here

autocomplete drop down list

I have several sheets in a workbook. A list of product codes, 76 rows and growing in one sheet. Another sheet contains an invoice template I created. In the invoice sheet, left column is where I'm hoping to place a drop down list, that when I start typing it will automatically begin filling in...

www.mrexcel.com

 

[dpaton05]

Up to approximately 200 names.

Thanks for the link, I will have a look.

 

[dpaton05]

I followed those instructions but it doesn't seem to auto fill as you type.

 

[Michael M]

Ok, I tried another page, and it worked fine...with Step by step instruction

How to autocomplete when typing in Excel drop down list?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com

 

[dpaton05]

I have followed the directions but when I start typing, nothing happens and when I click on the combo box to get the list, the list is blank. The list of names are also stored on another sheet.

Also, when I click on a cell around the combo box, I get the error of variable not defined and it highlighted "cancel" in the code. I defined it as boolean and that stopped the error occurring but still did not do anything different.

 

[dpaton05]

Can you help me with this Michael please?

 

[dpaton05]

I do not know how I am going to go about this. Do you think that access might be a better choice of programs to create this is?

 

[Michael M]

Ok, another method without the code

How can I add autocomplete to an Excel drop down validation

I have an excel column where a drop down validation is performed on a list on a separate sheet. I would like to allow the user to start typing in the cell and have the names on the reference list b...

superuser.com

In the linked cell section of properties you will need to reference the sheet, ie, Sheet3!G1:G7
You will also need to tell the combo box to put the answer, ie, linked cell, A1
Remember....Google is your friend !!

 

[dpaton05]

Thanks Michael but there is something I am not sure about. In the instructions, it says:

• Scroll down to select, 1-fmMatchEntryComplete in the MatchEntry Field
• Then reach to Linked Cell and Fill Cell address where you want to fill data, in shown example is C116.

I found the MatchEntry field and it was 1-fmMatchEntryComplete but I was not sure what that meant by "reach to linked cell and fill cell address"