@@GyanOnTube We have to say much more thank you to you Sir...Your work and ideas really amazed us...Your techniques of teaching are mindblowing ...Big Sallute to you Sir..Lots of love from Nepal🇳🇵🇳🇵🇳🇵🇳🇵🇳🇵
Sir G, aapki awaz badi Madhur, Mishri ki tarah ek dam mithi hai..... Sunte hi, kano se, dil me utar hi jati hai. Aur kafi saral bhasha me samjhate ho, ki ek layman bhi samaz jaye.... Thanxxxxxxx. Dhamyawad.
Hi brother, your videos are superb... In this video is there any chance to add excel file name to the consolidated sheet.. that means I need to get the file name and sheet name from which it came. Thanks for the excellent stuff...
Hello, I have a large number of data in one sheet. I need to allocate 1000 rows/ person. Instead of manual effort or macro, provide me shortcut for the same. Thank you
@@anupamaashokahirwar4175 aap mere channel mein search kar sakte ho aapko bahut video mil jaayegi..mein bhi search karunga to time lag jaaega..more than 300 videos hai
Hi Sir, @gyan On Tube. Thank you for sharing video. I have one concern. If I make any changes to other tabs, the same changes are not reflecting in consolidated tab. Pls le me knw the solution for this. Thanks in advance
Bhai RAW MATERIAL b diya kro hume, hum. practice kese kregy yar... video dekh k khud karne ka maan karta ha.. lakin koi dhang ki files nahi mil paati... please brother send me all excel RAW MATERIAL listed in your youtube video at my email I'd email.karan90@gmail.com
Sir you are great unique creator and innovator....Excel..GrandMaster...
Thank you so much for your valuable comment
@@GyanOnTube We have to say much more thank you to you Sir...Your work and ideas really amazed us...Your techniques of teaching are mindblowing ...Big Sallute to you Sir..Lots of love from Nepal🇳🇵🇳🇵🇳🇵🇳🇵🇳🇵
@@GyanOnTube And its a great pleasure to received reply from your side..Thank you so much..
Thank you so much for your kind words..🙏🙏🙏
Thank you so much again 👍👍👍🙏🙏🙏
Sir G, aapki awaz badi Madhur, Mishri ki tarah ek dam mithi hai..... Sunte hi, kano se, dil me utar hi jati hai.
Aur kafi saral bhasha me samjhate ho, ki ek layman bhi samaz jaye.... Thanxxxxxxx. Dhamyawad.
Thank you so much..aapke comment ke liye bahut bahut shukriya 🙏..is video ko share zaroor karna...❤️
Superb its worked and helped me a lot... Thank you so much.
Happy learning 😊
Most useful video , thanks sir
Thank you so much
1 min ke andar itna fast ho sakta hai.. wow.. unbelievable..
Thank you so much vikas
you are the God of Excel.
Aap logo ki blessings hai..🙏🙏🙏
Wah bhai ek dum badiya, kuch macros ka video banaona please, like WhatsApp automation.
Nice suggestion..sure will do this as well
Thanks. Managed to do it though I don’t speak Hindi 😎
Thank you.. great work
Very knowledgeable video
Thank you so much 🙏🙏
So much helpful .. Thanks a lot
Thank you so much
Hello..... Very excited video
Excellent
Stay connected
Thank you so much
EXCELLENT
Sir kindly explain on custom column
Sure will prepare another video on that
18 part is missing
How to get filter if i filter in one sheet automatically same need to be filter in existing sheet
We have that option as well
It's magic ETL Tools..
Very true..
It works, thank you (Y)
Thank you so much
Good work bro🎉
Thank you so much
Nice
Thank you so much
multiple workbook mein similar data ho to single workbook mein append kaise kare?
Same option se
nice
Thank you so much..fo not forget to share this video
Thank You
Thank you so much..do not forget to share this video
Hi brother, your videos are superb... In this video is there any chance to add excel file name to the consolidated sheet.. that means I need to get the file name and sheet name from which it came. Thanks for the excellent stuff...
Yes you can definitely..you can merge append with the help of query editor
Sir kya aap computer 🖥️ Course me Full video bna skte h ya Couching de skte Hain
Aapko kya excel ya advance excel ki coaching chaiye
Sir hum agar connection ki jagah pehle hi table waala option select karte to bhi kya yeh data Excel mein load ho jaata
Hanji bilkul ho payega
Hello,
I have a large number of data in one sheet. I need to allocate 1000 rows/ person. Instead of manual effort or macro, provide me shortcut for the same. Thank you
You can create through pivot as well
@@GyanOnTube how? Can you guide me?
I already have video on that topic , please check in my channel
Sir nice video
Ye 2007 excel me chal jaayega sir
Nhi ...2007 mein power query ka option nhi hota
@@GyanOnTube ok sir
Sir get data ka option excel 2010 main nhu araha kahn hota hy
Aapko aapna office 365 mein upload karna hoga
super
Thank you so much..😊
hlo sir
append kerne per three or more table wala option nh aa rha
pls help me with
Usme aur options aata hai aap check karo
sir can we bring data with format
Yes
excel 2019 me ye option nhi he kya
Nhi only in office 365
Load to option grey hai.
Try complete step without skipping
I had to merge 172 tabs into 1 sheet..it ran out of memory
What is your system ram
sir when we add new sheet in it.how we will do it
Just apply same steps
Bhai baki sb thik ho gya but date ka format change ho gya sb ka
Have you done any thing additional
Sir get data ka option nhi aa rha
Its called transform query
Or Excel spreadsheet me Full course provide krwa skte Hain
Aap mere channel mein dekho excel related bahut se course available hai
@@GyanOnTube
Uska 🔗 link de sakte h aap
@@GyanOnTube
Or sir agar AAP Digital marketing sikha skte Hain to btayiga jaroor
Language Hindi hai
@@anupamaashokahirwar4175 aap mere channel mein search kar sakte ho aapko bahut video mil jaayegi..mein bhi search karunga to time lag jaaega..more than 300 videos hai
मुझे दिक्कत ये आ रही है जब दूसरी शीट में एंट्री karta हू तो master file a entry नहीं आ रही है क्या करू
Reference create karo
@@GyanOnTube देखता हू जो options ढूंढ रहा हू वो reference करके होता है क्या. देखता हू जी
नहीं हुआ entry update.. Power Query main wo new entry update hi nahi show हो रही है.. इसलिए master file main updates नहीं हो रही है
Sir agar formats same na ho to kese merge karenge
Tab to aapko manually hi karna hoga
Sir agar bahut sare columns ho to manually karna bahut mushkil hoga
To aap usko standardized kar sakte ho..for first time then you can apply merge Query
How to mobile?
Sorry
2 minutes in and I'm still trying to figure out if this vid is in English or not 🤣
😊
🙏
Thank you so much..do not forget to share this video
Get data option he nhi mil rha sir ji😅
Kya aap office 365 use karte hain
Okey ji thanks u
@Siddthetraveller np
Hi Sir, @gyan On Tube. Thank you for sharing video. I have one concern. If I make any changes to other tabs, the same changes are not reflecting in consolidated tab. Pls le me knw the solution for this. Thanks in advance
It will definitely reflect..you just need to refresh your consolidated file
Bhai RAW MATERIAL b diya kro hume, hum. practice kese kregy yar... video dekh k khud karne ka maan karta ha.. lakin koi dhang ki files nahi mil paati... please brother send me all excel RAW MATERIAL listed in your youtube video at my email I'd
email.karan90@gmail.com
Aap mere power bi ki series dekh sakte ho usme saare excel files hai..