Apko nahi malum ki me apke vdo dekhne se pahle sirf excel me likhna and usko font wise ya color karne ke alava kucha bhi nahi ata tha but aj me puri sheet ko bana ke usme kahi trah k formula laga ke mere boss ko impress karta hu jisse unhone khus ho k meri selry bhi badha di hai Me apka bahut bada abhari hu So ap ase hi bariki vdo banate raho and mene jo apko ek thoda sa pucha hai usk bare me jarur batay so tnx again
आपका बहुत-बहुत धन्यवाद कि आपने इस प्रकार का वीडियो लेकर आते हैं वह भी बहुत साधारण भाषा में, जो व्यक्ति आपके वीडियो को एक बार अच्छी तरह से देख ले तो उसको किसी प्रकार के दिक्कत का सामना ही नहीं करना पड़ेगा और किसी इंस्टिट्यूट में भी नहीं जाना पड़ेगा आपका बहुत-बहुत धन्यवाद सर
सुप्रभातम श्रीमान जी। मैंने आपका "show/hide data" आधारित संबंधित वीडियो देखा जो बहुत ही मजेदार था ।अब मै चाहता हू कि ड्राप-डाउन की सहायता से जिस प्रकार डेटा " Hide /show" होता है ,उसी प्रकार "drop-down "की सहायता से डेटा "Hide"न होकर ,एक साथ बहुत सारे "columns"मे " " formulas"के साथ डेटा चेंज हो जाये ।कृपया ऐसा विडियो भी बनाइये।
Its an awesome video. Weldone... Ek cheez puchni hai... Jese ham drop down row me branch code likhen, or next column me jahan names arhe hain, wahan branch numbers, branch manager number, operation manager numbers sab side by side aajae, Just one drop down list me branch code likhne se.. Ye kese bnega.. Plz b btayein..
Deepak ji kya hum apme excel m apna data ko kisi local disk (D,E) m rakh ke kisi dusri file m apna data dekh saktay h jo hamari in file se connect ho or hamara data sahi aata rahe agar hum us m koi bhe entry kare to Please tell us Thanks Yogesh panchal
Sir Deepak Ur way Of teach 2 Good.i like So Much few days Ago i was Join coaching for Class There Is Not wel to learn when friend toald me About U I daily Learn Listen Form ur classes
Nice sir iski jarurat bahut dada thi sir ek or cheez yadi hum invoice mail value dalte jaye to humare pass jo data h usme se sab kuch minus hota jaye ye kese karenge sir plzz arjent h plzz btaye.
Sir apke video bahut hi kam k hai so tnx But is vdo me ek bat aur apne bata di hoti to bahut hi maza aa jata Jese ki apne bataya ki jo no. Next column ya row me fill karte hai to automatic cell ban jata hai is tarah dat bhi automatic aa jay jis din hum usme kuch likhe jis din us sheet ko kholke likhne jay tab vaha date us din ki automatic aa jaye Please i requested ye bhi bata do sir
Thank you for this tutorial. I have been following all your videos and have learned a lot. I would like to know how to how to use dynamic vlookup for Multiple Value which you unfortunately did not show in the video. As per the tutorial do we need to put a Vlookup formula in each cell for it to update the multiple columns? May I please request you to show us how to use Dynamic vlookup for Multiple Value 🙏🙏
Hello, Deepak ji, good morning. aap ki tarah se bahut badhia xl ki very useful & day today works ke liye fayeda wala video aa raha hai. Thank u very much. is video me sab kuch thik thak hai but one thing - mein ek data banake us sheet ko formula hide kar diya to us ke baad jab mein kuch data entry karta hun to ye table update nahi ho raha hai. uska kuch solution hai kya ?
Sir ap ne ek row me formula lagaya hai, jo k ek row tak limited hai. Ab hmein 6, 7 rows me data search krna ho, to kese krengy? Jahan ap ne drop down bnaya us k bary me keh rhi hun k ek row me lagaya hai formula, ek se zyada me kese krengy ?
thank you for this video , but there is a issue arise when my data is one sheet and want to create dropdown list in other sheet then it wasn't working . So please help me out from this issue . thank you ..
Hello brother, i do follow ur videos and they helped me very much and am so thankful to u. Would u please show to copy data from one sheet to another sheet using vlookup, which ever formula suits. Plz guide me.
Nice sir Sir ek eisi video banaya ki sn style code particular uske bad si 30- 46 s m l xl xxl xxxl yaisaa column wise automatic kaisa banaya sir please esaka sales invoice ka vedio banaki jiyana sir
Dear main Chahta hoon Kay vlookup say data find karnay Kay baad us record main kuch edit karo tu jahan say deta vlookup Kiya hai us jaga data khud he update hoo jaye.... Is that possible?