Searchable drop-down list for multiple cells

Hello Friends,
In this video you will learn how to create searchable drop-down for multiple cells.
Please download this excel file from below given article:
www.pk-anexcel...
Searchable drop-down for single cell in excel:
• Excel Tip: Searchable ...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcel...
Facebook:
/ pkan-excel-expert-9748...
Telegram:
t.me/joinchat/...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert

[@markalvinvillanuevasoriano5468]

This is what I'm looking for like thousands of years. Thank you so much ❤️

[@PKAnExcelExpert]

Glad I could help!

[@raghu_rsb]

@@PKAnExcelExpert Thanks Me too !!

[@chaneldutremble]

I just spent the last hour looking for exactly this and no one could give me this result, or this easy approach. You're a genius. Thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@santhoshnarayan6934]

same here.. :) I got this finally

[@PKAnExcelExpert]

Thanks Santosh

[@undrakhbadarch4102]

finally i found exactly what i wanted :) your tutorial is absolutely amazing ! thank you so much

[@shivkumargourav5059]

Countif ke baad samajh mein nHi aa raha hai jaise * se pehle

[@michellecamacho6718]

You are a genius!!! This was exactly what I was looking for and it was perfectly explained so it was easy to understand and replicate.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@culpeperbill]

Nicely done. This problem has been haunting me for a few weeks. Your step by step tutorial was perfect. Cheers.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@kimstrazde1129]

you are a savior! I found few videos doing this but only on a single cell reference. this is exactly what I need. thank you!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abhishakya5263]

@@PKAnExcelExpert
Sir...How to auto open drop-down box when cursor in that current cell.

[@abhishakya5263]

@@PKAnExcelExpert
Sir ...agar koi koi cell (G7) hai... jisme paid ya to pay Likhna mandatory hai....agar cell blank ho to data validation wala alert aa jaye...yeh kaise ho sakta hai

[@ecooney007]

PK, thank YOU! I have access to MS Teams/Office 365 and online version of excel, but I am bound by an old 2016 version of the desktop excel, so anything I do can only rely on the older excel functions. I have a sheet where you can create a row by selecting items in a drop down in the first column, but of course there are 3,000 plus items in the list, and you must scroll through most of them to get to the item you want. This will help us greatly, you are awesome!💯

[@gopalkalimuthu149]

You are Genius Man...Your tricks helped me to reduce my File Size from 4.9 MB to lessthan 2 MB...Great!!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@leslieamangala148]

thanks!!! watched many videos for searchable drop down list for multiple cells. couldnt get it right, yours
finally worked.

[@shakhobiddinnakiev6767]

man, thank you biggest !!! You literally saved many more peoples life! Fantastic job!!!!!!!!! GREAT RESPECT!!!!

[@ibrahimaluva652]

Very very helpful..... You did an amazing job with this!.... Thanks a lot....

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@MrSquax]

You're a life saver. This tutorial saves me A LOT ! Thank you so much.

[@PKAnExcelExpert]

Glad it helped!

[@AbuRushdah]

You are a saving grace!!!!!!!!!!! I love youuuu!!!!! I almost had a heart attack when I could not do the searchable drop down on multiple cells... Thanks you so much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@renghahenish3023]

Brother you are a life saver

[@PKAnExcelExpert]

My pleasure

[@angelynlthompson]

Thank you, thank you, thank you! I have been searching and consuming content for five days to solve my issue with a invoice template. And hands-down you have the BEST solution. I was able to follow and my form now works. I've just subscribed to your channel and look forward to learning from you. Many blessings to you!!

[@rimaafrintina5927]

you are genius!!! Thats all I can say!!! Hatts Off!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@ashimakhera9447]

I have been searching this for last two days, and your method is the best. very well explained and right on.. Thank you so much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dinethprabash1001]

this is better than most of the related videos

[@elmiragalarov6293]

Perfect!!! That's what I searching for many time. Huge thanks!

[@PKAnExcelExpert]

Most welcome🙏

[@yohanesrotinsulu3461]

BROOOO U HELPED ME A LOT THANK YOU VERY MUCH, MAY ALL THE GOOD FORTUNES COME TO YOU ALL DAY!!!!!!!!!!!!!!!! I LOVE YO BROTHER!!!!!!!

[@PKAnExcelExpert]

Glad to hear that

[@manissery1956]

This is the best presentation on the subject. Many thanks.

[@PKAnExcelExpert]

Wow, thank you!

[@thevegboxman]

Great video, wish I had found it a lot sooner! Has now saved me loads of time building a costings work sheet Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chintanthakkar821]

I almost searched all the websites on the internet for this and didnt find anything, i was about to quit believing that it is not possible in excel 2010 until i saw your video. this is very impressive!!!!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chintanthakkar821]

@@PKAnExcelExpert The drop down does not work when the file is protected and shared. Do you know why?

[@amitrana4473]

@@PKAnExcelExpert sir thanks for providing this but by using that code i cant use copy or paste function in sheet could you please help..

[@imtisunuplongchar6090]

Been struggling for this about a week... and this video solved it.. Thanks..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sarveshmaurya5136]

You are genius bro.... Superb....👌👌👌👌👌

[@PKAnExcelExpert]

Thank you so much 😀

[@agungparasara9261]

fast & concise explanation. thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mnkum4163]

You are realy genius thank you so much

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@victorvillanueva9558]

Easy video to follow, thanks, this is exactly what I was looking for.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rickybobby09101980]

High Five on an awesome tutorial video. This help me achieve exactly what I wanted to do. Keep up the great videos!

[@PKAnExcelExpert]

Thanks

[@generalbi6352]

This is a supremely good method, thanks for sharing.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@joellimyixuan6611]

You're a life save mate! Thanks for making these videos!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@blackhorseexcellencepvtltd4297]

This is simply superb.! Very very helpful. One suggestion, while using Cell function, we can use Cell("Contents") to avoid using Indirect along with. Thanks a lot. Cheers.

[@saswatranjanbarik]

Well demonstrated Thanks

[@PKAnExcelExpert]

Glad it was helpful!

[@yogeshpujari8345]

Thank you Sir , this was very helpful 💐💐

[@PKAnExcelExpert]

You are welcome

[@johnm2780]

Cheers pal, this was exactly what I needed. Excellent step-by-step instructions. All the best

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ranarizwanahmed]

this is one of GREAT technique I ever learned, THUMBs UP, Thanks PK, you really save my TIME

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ranarizwanahmed]

@@PKAnExcelExpert let me know one this should I save file as .xlsm after writing in VB?

[@genene012]

Thank you so much for this tutorial!! This really helps in getting my work done faster and easier :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tim_ies]

Thanks a million, it was easy to follow and worked as expected. Really useful tutorial, appreciate it!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@blckrvn89]

This is exactly what i'm looking for!! Thank you so much!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gruffalocrumble494]

OMG thank you so much. I have been searching forever for this solution. Many many thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@breem8257]

You are a genius sir!
That rocks so hard 🤟
Thank you Professor!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ACCNTSBSTTBR]

great explanation sir ji....excellent trick.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ACCNTSBSTTBR]

SIR I WANT TO SET 3 DIFFERENT LIST ON DIFFERENCE RANGE OF ONE SHEET,,,,PLEASE GUIDE HOW I CAN DO THIS

[@lenac3587]

Excellent video!! Really appreciate you showing this superior technique in doing google search like auto text. Now we need to figure out if the dropdown can auto dropdown when the cell is clicked rather than clicking the arrow to view the drop down, possible? That would be the ultimate icing on the cake!!

[@balakumaran75]

Superb video. Great ideas

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lotsoftopics8150]

Thanks, i will try tomorrow 😮

[@PKAnExcelExpert]

Most welcome🙏

[@soumikghosht]

You really are a saviour!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rosacardozo416]

Thank you SO much! You made understanding thus very easy. Thank you 😊

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sophiap4579]

Thank you, this was super helpful!

[@deepkarira19]

Thanks, helped me create my file

[@PKAnExcelExpert]

Welcome

[@dance4836]

Thank you so much! You are wonderful and so talented.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dashrathpanchal8393]

Very good trick of using searchable drop down list for multiple cell, Actually I was searching for the same solution.
Thanks PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sajadmk6618]

I recently watched... it's brilliant

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@memore4986]

It's great! Thanks Brother.

[@PKAnExcelExpert]

Glad you like it!

[@ca.lokenderchauhan2605]

Pls make video in Hindi . Your knowledge is just exceptional.

[@ahmedhamdy6930]

this is a marvelous patened

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@yogeshpareek6697]

Thankyou so much ❤❤

[@PKAnExcelExpert]

You're welcome 😊

[@yasithsandaruwan514]

Thank you so much for this solution

[@yahno3]

very useful and well explained! thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pettertesla2741]

Great Job...if can search without klick small arrow and wiil appears the result is better..

[@Theuniquecreation1999]

thanks a lot .. you desearve a like bro ..

[@PKAnExcelExpert]

Thanks a lot🙏

[@nellysachs]

Thank you so much! I finally found what I want.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pradhanrajiv6722]

Thank you 🙏🙏🙏🙏🙏🙏🙏

[@PKAnExcelExpert]

Most welcome

[@Elbasha88]

Thank you so much keep it going

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MahyLune]

1000 like and saved for later!

[@PKAnExcelExpert]

Thanks a lot🙏

[@DragonsAreHungry]

thank you SO MUCH, that is exactly what I wanted to do!!! regarding the error at the end (which you created the macro for) - in my case it only needs to doubleclick into the cell (like where you wrote Zim) as if I want to continue writing and the dropdown choices update

[@madhavneupane7947]

very informative...thanku

[@PKAnExcelExpert]

Most welcome

[@medic1dl]

This video is exactly what I was looking for. Thank you so much.

[@GodWillIncreaseNitzborn]

Thanks PK! This looks awrsome... I like the cell address string... Excited to use...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Quran-N-Islam]

Thanks dear for such a amazing and informative video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@NNTechnologies]

You have an amazing skills in Excel..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@GR-gq1us]

Excellent!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@leduythang90]

Thank you so much!

[@TushkiTricks]

Finally i got it, thnx

[@vipankhatri161]

great creativity fantastic may god bless u...!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mihirranjannath5997]

thank bro a lot..!!! it's very useful

[@pratipalsinhjadeja6167]

Thank a lot.
I want one more feature here.
Is it possible here whenever I search any word from list the auto suggestion list will appear without clicking on scroll down button.
Same as list appear in various websites.

[@asadost258]

Did u find from any other source?

[@aldrinfelix8927]

Excellent.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@majidsiddique8227]

Well Done PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abhishakya5263]

Sir...How to auto open drop-down box when cursor in that current cell.

[@abdulghaninajm2924]

thank you thank you thank you🙂🙂🙂

[@PKAnExcelExpert]

Most welcome

[@Jeevaji14]

bro your legend

[@PKAnExcelExpert]

Thanks

[@channelkuno5732]

thank you so much

[@PKAnExcelExpert]

Welcome

[@aveshansari3711]

Thank You Sir for this Video My project Sitt 1 Month I try This One Thank You Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@khalidkazi3293]

Excellent bro

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mushtaqali267]

I am from Pakistan beta u r mashallah excellent trainer around the globe keep it up
Why I call you beta because I am over 50

[@PKAnExcelExpert]

Thanks for your valuable feedback and blessings 🙏

[@43FERDINAND]

Thanks for this tuturial sir, it's really usefull.

[@PKAnExcelExpert]

Thanks for your appreciation. Request you to please share this with your friends and colleagues.

[@Excellent625]

Thank you. What if we want to do 2 or more different drop list. How can i diffrenciate between them using cell formula. Thank you once more. Your videos are really helpful.

[@christianath95]

See 7:45, just make another validation connected to different list

[@jatinacharya-jeeamtradelin4089]

thank you bro.......... this is amazing......

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@KotsiF1]

Perfect! Thank you very much!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ZeroBytesYT]

thanks a lot.
I recommend using automatic calculations, to prevent slow calculations

[@jaihind_jaisanatan]

Very nice sir, very important and real productive video, now kindly make a video on setting Excel chart scale based on minimum & maximum cell value. Please

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@luvjoychoker7807]

Thanks! Much appreciated

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abdulhamidalhaddadi2255]

Thank you

[@PKAnExcelExpert]

Most welcome

[@TheMuffinMister]

You are a hero

[@PKAnExcelExpert]

Thanks a lot

[@AnzaOwner]

You made my day ! Thank you very much :)

[@salahaldeen7924]

indeed, very helpful video. thanks from Oman

[@user-ed5jj9mz6i]

THANKS SIR JI

[@tshiamozankere8689]

Genius!

[@PKAnExcelExpert]

Thanks a lot

[@callumwright5874]

Hi PK. Great resource and helpful. Quick query regarding it however, since I’ve added the VBA Macro in as well, I’ve lost the ability to be able to copy and paste cells. When I highlight and copy, it will do the dashed lines, but when I next click it disappears. Any thoughts?

[@md.mehedihasannahid1477]

Thanks.

[@PKAnExcelExpert]

Welcome

[@mohamadfawaz1928]

EPIC trick million thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback