It's really helpful thanks a lot more making informative videos like this though I have a small questions,how to apply this dependent drop down in complete row, as when m trying to do so by ctrl+D it's not happening. Please suggest
Good explanation! Suppose I need to create a sheet with country, state, district etc. Now I select India> UP>Kanpur. But is it possible, if I select Kanpur automatically UP & India would populate?
sir bahut hi acchi jankari hain sir ek dependent list colour wali banana jisme automatic hi colour change ho jate hain sheet 1 se sheet 2 par sir ek iska bhi video banakar upload kijiye
Thanks for the awesome trick. I have one question. How to remove the space from the drop down list if you don't have equal number of cities under all the countries? If you have only 3 cities under Japan, then there will be 2 blank options in the drop down list. How to fix that?
Best video in excel..... I Like a master file in Excel but I m not make it........ please can you make it master file this sub 👉 like product order list . ( Hint :- sheet 1(master sheet) all products details or rate / tax value Sheet 2 is order sheet......... Sir is the amazing trick....... Plz make it
So, I have one situation here. Is it possible to make a dropdown column where customers are given the name of the supplier. If the customer selects that particular supplier the column on its left should automatically display that particular suppliers Roll number?
Sir me apke sare vedios save krke dekhta hu ap drowpdoun par ek badi sheet pe drowpdoun lagao jis se sab change ho me office me work krta hu jisme badi badi cansols bani hui product ki so plz ap ek koi badi sheet banao or vedio banao thank u
ish baar dependent drop down list ki ek aishi video banao.. jo puri detail main ho...condition niche di gai hai.. 1. main matlab user ek colom main gya jaha sirf customer ka name likh diya.. ab jab next colom main jaau then ush foam main dependent drop down list main sari value automatic aajaye .. bina list scroll karein.. aur ek badiya ek work book ki dusri sheet main table bani ho thodi smart view type user friendly .. ya ek work book main smart table data bana ho aur dusri work book ki work sheet main foam .. jaha bas ek customer ki drop down list select karo aur jo comman detail hoti h jaise like phone no ,address, reference name ,,uski firm ka name dusre colom automatic aajaye... bina scroll aur select ke... 2. aur jo dusri detail hai at all kisi main bhi underscore ka matter nahi ..ek proffessional dikhna chaiye..
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
It's really helpful thanks a lot more making informative videos like this though I have a small questions,how to apply this dependent drop down in complete row, as when m trying to do so by ctrl+D it's not happening. Please suggest
Very👌👌👌👏👏👏👏👏nice
Mujhe excel ki koi knowledge nhi thi apke channel se knowledge se aaj me achha job kar raha hu ??????
Very good
Hello depak ji can u plss tell my how to create a dropdown list which allows duplicate entries
Aapka video hamesha kafi accha rahta hai hamesha sir,
bhai mien ne aj tak youtube par koi esa youtuber nhi dekha jo etni logic aur acha method se samjhata hon jitna powerfull ap samjhty ho
आपका समझाने का तरीका बहुत शानदार है,, बहुत बहुत धन्यवाद आपका
Very nice Sir
VERY VERY MUCH THANK YOU
Bahut badhiya tarike se samjhayaa hai. Facts bhi clear kiye hain. Kuch log just kaam chalau hi karte hain. You are good brother. Thanks and Regards
Sir ji apko salute kitne din se yehi dhund raha tha main... mil gaya.... lvu lvu lvu😘
Dependent drop drown list in Excel... Fantastic...
Superb video. Easiest & best way to create a drop-down
Video ekdum mast tha.
Thank you sir. Isse pahle mujhe pata hi nahi tha ki aisi list bhi hoti hai 👌👌👌
Thank you so much .. I watched so many videos to understand but failed. This time understood very well...
बहुत ही अच्छी तरह से समझ में आ गया 🙏
Very helpful and easy to understand thanks Deepak
GOOD WORKING DEEPAK BHAI MAINE APPKA VIDEOS DEK KE BHAHUTH KUCH LEARN KIYA THANK YOU SO MUCH SIRJI
Aapki language bhut achi hai batane ki ,
sir plz advanced excel me financial functions pe vdo banaye ....apke vdo bahut helpful hote hain..thanx sir
लय भारी सर समजले व प्रत्यक्षात केले व मला जमले कारण तुमचे बोलणे खुपच छान शब्दन शब्द कळतो लगेच धन्यवाद सरजी!
VERY VERY MUCH THANK YOU
SIR ---------
बहुत अच्छे मज़ा आ गया
ua-cam.com/video/mcZt7o0IaTQ/v-deo.html
Good explanation!
Suppose I need to create a sheet with country, state, district etc. Now I select India> UP>Kanpur. But is it possible, if I select Kanpur automatically UP & India would populate?
DEEPAK SIR .. I VERY LIKE YOU AND UR TEACHING SKILL..
.
MUJE ITNA MERI COCHING SE SIKHNE KO NHI MILTA JITNA AAPSE MILTA HE .. THANKU SIR
Keep up the good work learning daily from u
very nice video sir..bahut easily samjhaya thankx......sir ji
bht kamal videos hn apki
Thank u so much keep making videos👌👌👌👌
Thnks deepak bro... nyc..... aaj mene bahut kuch sikha bro is video se
Thank you so much bhaiya. It is realy helpful.
👍
Awesomely explained. You are better than so many professionals of international repute
Bahut Dhanyavad.
🙏easy process apne bataiye...
Thanks.
But ek query hai koi country field me supposed ek city kom ho tahb is processe hoga?
Very informative video....loves your explanation procedure....Thanks..
Buhat buhat informative video Sir. Alot of love respect for you from Pakistan
Sir aap very good teaching karne hai.thankus
Great information...thanx sir
Ek No.
😁
Really very very helpful. Very nice sir
Very Nice Sir
Thank You So Much 🙏🙏🙏
sir bahut hi acchi jankari hain
sir ek dependent list colour wali banana jisme automatic hi colour change ho jate hain sheet 1 se sheet 2 par
sir ek iska bhi video banakar upload kijiye
Thanks for the awesome trick. I have one question. How to remove the space from the drop down list if you don't have equal number of cities under all the countries? If you have only 3 cities under Japan, then there will be 2 blank options in the drop down list. How to fix that?
Excel ka badsha dipak Vai🖤
Thank you so much
It helped me exactly I was looking for.
Thanks for creating such a simplest video
Best video in excel.....
I Like a master file in Excel but I m not make it........
please can you make it master file this sub 👉 like product order list .
( Hint :- sheet 1(master sheet) all products details or rate / tax value
Sheet 2 is order sheet.........
Sir is the amazing trick.......
Plz make it
Thanks sir.
Very very useful lesson.
👌👌👍👍🌹🌹
Excellent
Superb sir...easy to understand
Sir thank you very much
Sir your video is too good.
bahut accha sir u r rocking
THANK YOU SIR JI
SUPERHIT VIDEO
Ab think ho Gaya .thank u very very much sir.
😇
Good teaching
New subscriber! very informative n detailed explanation.
Thanks dear me ye hi video fine kr rha rha tha... Subscribe Done Like done Bill icon Done
bahut hi upyogi video hai
thanks sir ji
Love you sir from Pakistan 🇵🇰🇵🇰🇵🇰
Very useful video.Thanks.
Good one
So, I have one situation here. Is it possible to make a dropdown column where customers are given the name of the supplier. If the customer selects that particular supplier the column on its left should automatically display that particular suppliers Roll number?
Shukriya aapka
Super sir😮
Thank you sir
Useful drop down list
Video good exaplane
Very Nice
Thank you Deepak... Informative videos
Informative 👍
Superb video sir i really like it.
Yahi kaam aya. 🙏🏽
Sir me apke sare vedios save krke dekhta hu ap drowpdoun par ek badi sheet pe drowpdoun lagao jis se sab change ho me office me work krta hu jisme badi badi cansols bani hui product ki so plz ap ek koi badi sheet banao or vedio banao thank u
Ok g
Very productive.
Bohut acha sir
You are a life saver... channel subscribed
+Abdul Kadir Tambe 👍👍👍
Best teacher.
Good night sir,
Good information
Super Sir
Nice Video brother
Perfect...👍
🌹🔥 राधे राधे🔥ARK🌹🏹
V nyc video sir
Superb sir
Thanks for making videos
Explained in very simple way..Amazing 👍
Thanks sir ji
Nice work deepak sir
bahut badiya
You are Excel man
Very helpful
Thank you sir
Very good video
NICE SOUND QUALITY
Nice deepak. Thanks
Dropdown list aur thoda video bhejiye apaka e learning lesson bahut acha lagarahay
Thank you sir.
Bahut hi Sundar he video keep it up for helping thanks alote
जबरदस्त
Nice work Deepak.
Thankyou so much dear
ish baar dependent drop down list ki ek aishi video banao.. jo puri detail main ho...condition niche di gai hai..
1. main matlab user ek colom main gya jaha sirf customer ka name likh diya..
ab jab next colom main jaau then ush foam main dependent drop down list main sari value automatic aajaye .. bina list scroll karein..
aur ek badiya ek work book ki dusri sheet main table bani ho thodi smart view type user friendly .. ya ek work book main smart table data bana ho aur dusri work book ki work sheet main foam .. jaha bas ek customer ki drop down list select karo aur jo comman detail hoti h jaise like phone no ,address, reference name ,,uski firm ka name dusre colom automatic aajaye... bina scroll aur select ke...
2. aur jo dusri detail hai at all kisi main bhi underscore ka matter nahi ..ek proffessional dikhna chaiye..
Great
Hi Deepak Your videos are really useful, I want to use searchable drop down with this sheet. because my data is very big
ua-cam.com/video/bgmEgFyoUSA/v-deo.html. Searchable drop-down for multiple cells 👍
I want auto calculator salary bill with worker presence
How to extract photos database through dropdown list ?? Please advise