I need help with combine no repetition worksheet & searchable worksheet into one worksheet

[patriots]

I need help with combine no repetition worksheet & searchable worksheets into one worksheet drop down list on the BYE WEEKS worksheet. I not sure how do that.

I need also put new drop down list put in BYE Week worksheet in all green highlight areas


If possible tell me how you made new list on the file please

Thanks You

Patriots

[patriots]

here picture of I want

[Glenn Kennedy]

Hi. Your sheet crashed my PC a couple of times, so I stripped it back to its basics to get this working for you. It has the functionality that you want (I think). Check it over. Same as before. Enter search letter(s) in column H and click the DD handle. Thereafter it all works...

Let me know if it's OK.

[patriots]

here picture of problem


Thanks You

[Glenn Kennedy]

Try this:

https://support.microsoft.com/en-us/...a-86f8d4f9fe20

If not, will check it over in the morning.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[patriots]

https://www.mrexcel.com/board/thread...2#post-5603936

[Glenn Kennedy]

So, is it working or not??

[patriots]

is working. I have question possible have list show if I don't type anything in cell I use drop down?



I try create same thing on my own I can't get it


Thanks You

[Glenn Kennedy]

I do not understand. If there is nothing typed in the dd box you want to see???? What??

[patriots]

when I use drop down thereno list of teams in drop down

[Glenn Kennedy]

Well, no. You need to enter a search letter....

[patriots]

ok thanks you