In excel 2007 you can select data from another sheet while creating dropdown list... But you can do it in excel 2010 or all above versions... So If you are using excel 2007... You have to watch a video to create dropdown from another sheet.. And Link is th-cam.com/video/-IDqfwby5MM/w-d-xo.html
Me bhi 2007 hi use karta hu our mujhe bhi ye problem hua lekin mene socha computer me kuch kharabi he islye mene manage kar diya sheet 2 ka source ko copy karke sheet1 edit karke, lekin ab apka video bhi dhekunga ye video ka baat ki ap kese manage kiya☺
Sir, superb video he. Sir please isme ek option chiye muje ID pe picture shows and Hide ka option, jese kisi ka photo list me fit he lakin uska photo list me se delete kiye bina, without photo uska id print karna he agar aisa koi option ho to please video banao.
Deepak EduWorld thanks sir for reply...I am using excel 10, I got the point of drop down. I am asking ..there is many unique no. And every unique no. Has one image..I want to fetch images in second sheet without using drop down list ..just like we fetch value in vlookup .
दीपक सर मैंने अभी अभी आईडी कार्ड बनाने वाली वीडियो देखी थी कि उसमें ऑटोमेटिक कुछ भी नही हो रहा था जैसा कि आप की वीडियो कई आईडी कार्ड्स ऑटोमेटिक शो हो रहे है। बहुत ही यूजफुल वीडियो है, आपकी सर। शुक्रिया आपका।
Kahan pe or kya problem aa rahi h aapko... I think.. mailing me data jo liya hai excel se usme problem hai.. f1 f2 is tarhe se to nhi aa raha mearge feilds me
Deepak sir namaste.. apa ka invoice video deka super ta aur usiko toda modified karake use kar rahahu last 1year se so thankful you idea in exeal super... Danywad
Thank you. It was very informative video. Can we pull the photo from JPG file if the pictures are saved in a folder with Id number as the file name. Example: ID001.jpg
Sir, you are so very clean & clear for all the function with explained in Excel word. I request one thing for ms Excel 2016 how to use developer option please .
Deepak Sir, agar aise i-card banayenge to kya agar ek bar i-card bana liya formule se fir koi new student ka record add kiya to kya usaka i-card generate hoga ki nahi ..i mean data update hoga ki nahi..aisa to nahi ki fir se new data k sath wapas sab formula use karana hoga...
In excel 2007 you can select data from another sheet while creating dropdown list... But you can do it in excel 2010 or all above versions... So If you are using excel 2007... You have to watch a video to create dropdown from another sheet.. And Link is th-cam.com/video/-IDqfwby5MM/w-d-xo.html
Is ka liya thanks sir lakin i am using 2013 excel
Me bhi 2007 hi use karta hu our mujhe bhi ye problem hua lekin mene socha computer me kuch kharabi he islye mene manage kar diya sheet 2 ka source ko copy karke sheet1 edit karke, lekin ab apka video bhi dhekunga ye video ka baat ki ap kese manage kiya☺
Sir, superb video he. Sir please isme ek option chiye muje ID pe picture shows and Hide ka option, jese kisi ka photo list me fit he lakin uska photo list me se delete kiye bina, without photo uska id print karna he agar aisa koi option ho to please video banao.
Sir ji apna contact number send kr o ji mobile p kese banye
Deepak EduWorld thanks sir for reply...I am using excel 10, I got the point of drop down. I am asking ..there is many unique no. And every unique no. Has one image..I want to fetch images in second sheet without using drop down list ..just like we fetch value in vlookup .
Bahut badhiya
Aur aasaan hai
Thanks ji
दीपक सर मैंने अभी अभी आईडी कार्ड बनाने वाली वीडियो देखी थी कि उसमें ऑटोमेटिक कुछ भी नही हो रहा था जैसा कि आप की वीडियो कई आईडी कार्ड्स ऑटोमेटिक शो हो रहे है। बहुत ही यूजफुल वीडियो है, आपकी सर। शुक्रिया आपका।
Kahan pe or kya problem aa rahi h aapko... I think.. mailing me data jo liya hai excel se usme problem hai.. f1 f2 is tarhe se to nhi aa raha mearge feilds me
Excellent job
भाई अपने दिल खुश कर दिया
इतनी आसान तरीके से एक एक चीज़ो को बहोत ही सुंदर तरीके से बताया है
आपको दिल से धन्यवाद
😊
Sir u re the best, u very nicely told step by step how to make a I'd card
Very good explanation sir...Super
Thanks you so much sir ❤ I really like this video......🎉🎉🎉🎉🎉
Excellent vedio
Lajwab superb thank you sir
Thank you sir it helped me
lots of Love from Pakistan sir,,,bht achi video
Thanks A lot Sir ❤❤
Nice video. sir, aap ka javab nahi..👌👌👌👍👍👍
Apka samjhana ka method bhut bdiya hai
deebak sir muje is video ka kafi dino se intzaar tha thank u
Great idea very useful 🙏🙏🙏
Sir superb
Brilliant Yaar ..!
Thanks so much sir apki video's mei kuch new Sikhne Ko milta hai..
dear sir how can make print format multiple card with your trick mind blowing sir grate Sir you made so simple thanks sir
Admirable sir. I can't remain at ease without watching your videos
Thank you sir upon responding my comment
good and helpfull boss
Thank you sir 😊
Useful video, thankuuuuuu
Tysm for the lovely video. Got it in the first go. Looking frwd for more videos
You are great
Informative. Nicely explained
Thank bro Bahut Achchha Kar rhe ho aap.. 👍
Your all videos is very nice.
Bhut achha hair sr
Deepak sir namaste..
apa ka invoice video deka super ta aur usiko toda modified karake use kar rahahu last 1year se so thankful you idea in exeal super...
Danywad
😊😊😊😊😊👍👍👍👍👍
@@DeepakEduWorld thanks
Bahut bahut dhanyawad
Bhut hi accha he sir ji
Appreciable video
very very thanks
Very Helpful video
Bhut achha video tha
Bhohot mst bhai ji
Super video sir
Excellent video.
Excellent boss
Nice lecture..!!
Thank u sir for this helpful video
Thank you Deepak Ji, for sharing this valuable information.
😊
That is helpful...
Can we extract multiple id card at once? Like players with age above 30
Very nice lesson. Thank you sir for your valuables times share.
😊
😊
very very nice
awesome...
Good tutorials sir plz can u tell me how to print double side id card in a single page.
Is main Sirf single side card print Hoga yeh Sirf Student or Worker ki jaise college main Apne Gale main latkate Hain.
Excellent, 👍👍👍👍👍💟💟💟💟💟💟👌👌👌👌👌👌
very very nice sir gggg😀😀😀😀
shandaar sir g
Thanks Sir Nice Video
Very help full video Thank you so much💞💓💔💗💘💝💝💟🎻👌👍🎶💜💛💖
kamal he Dost
Excellent sir. Keep it up.
Bhai ek video banao full automatic salary sheet with I'd card and attandance dashboard
Very very nice trick
I ll send u.. Traing files today
OK sir I'm very very thankful to you sir.
Mr.danish000786@gmail.com
VERY USEFULL CLIP
Nice video sir
Gud video
Very impressively
great sir I have earned a lot of honor due to your channel in my office thanks sir G I have almost watched all of yours videos.
very nice ...
SUPERB SIR VERY HELP FUL
😊
Thank you. It was very informative video. Can we pull the photo from JPG file if the pictures are saved in a folder with Id number as the file name. Example: ID001.jpg
Brilliant sir.
Thanks deepak fr ART HOUSE DIMAPUR NAGALAND
😊♥️
you r best .. i m new in ur channel
very nice sir
Nice video thanks sir
pl. how mangal font to kurtidev vedio banana. id cord is very good idea. thanks
Thanks brother
Sir, you are so very clean & clear for all the function with explained in Excel word. I request one thing for ms Excel 2016 how to use developer option please .
Right click anywhere on ribbion.. Chose Customize the ribbon.. And check developer checkbox
Super sir
Thanks Sir 👍
very nice , Thank you
amazing great informative vdo
aap asa he aur video banaya
Top सर
Superb
Sir u are best. Loving from pakistan ❤
Niceeeeeeeeeeeee video bhai jan
Thanks sirji
Thak you so much sir
😊😊
वन्देमातरम।।✊🇮🇳
*ओम हर हर महादेव।। जय माँ।।*
🙏🔱⚔🚩💐🌳🌿🌱🥦
Fabulous
😊
Best
Nice sir video
Very nice
Osm sir
Deepak Sir, agar aise i-card banayenge to kya agar ek bar i-card bana liya formule se fir koi new student ka record add kiya to kya usaka i-card generate hoga ki nahi ..i mean data update hoga ki nahi..aisa to nahi ki fir se new data k sath wapas sab formula use karana hoga...
training file very useful thank you sir
gm boys .
Nice
nice sir
Thank you sir..
Picture lookup very good
tariq hussan
Nice bhai
Sir Ms excel main formula & data tab par aasaan video banayein please sir.
please wait .. i ll publish another video shortly on this topic 👍
Perfect sir