Excel Hack : Consolidate multiple excel tabs into one excel sheet | Merge all excel tabs into one

[@rissangole1436]

Sir you are great unique creator and innovator....Excel..GrandMaster...

[@GyanOnTube]

Thank you so much for your valuable comment

[@rissangole1436]

@@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🇳🇵🇳🇵🇳🇵🇳🇵🇳🇵

[@rissangole1436]

@@GyanOnTube And its a great pleasure to received reply from your side..Thank you so much..

[@GyanOnTube]

Thank you so much for your kind words..🙏🙏🙏

[@GyanOnTube]

Thank you so much again 👍👍👍🙏🙏🙏

[@nitinshukla914]

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.

[@GyanOnTube]

Thank you so much..aapke comment ke liye bahut bahut shukriya 🙏..is video ko share zaroor karna...❤️

[@tusharchalekar6508]

Superb its worked and helped me a lot... Thank you so much.

[@GyanOnTube]

Happy learning 😊

[@ravigaur48]

Most useful video , thanks sir

[@GyanOnTube]

Thank you so much

[@onlyexcel493]

you are the God of Excel.

[@GyanOnTube]

Aap logo ki blessings hai..🙏🙏🙏

[@preetipawar8142]

How to add new sheet in existing consolidated sheet

[@Rahulloveu143]

Wah bhai ek dum badiya, kuch macros ka video banaona please, like WhatsApp automation.

[@GyanOnTube]

Nice suggestion..sure will do this as well

[@SanviPatil2019]

1 min ke andar itna fast ho sakta hai.. wow.. unbelievable..

[@GyanOnTube]

Thank you so much vikas

[@khalidalisubhanallah2947]

Very knowledgeable video

[@GyanOnTube]

Thank you so much 🙏🙏

[@DecorousAgroFarm]

So much helpful .. Thanks a lot

[@GyanOnTube]

Thank you so much

[@foodiescsvlogs457]

Hello..... Very excited video Excellent Stay connected

[@GyanOnTube]

Thank you so much

[@michaelrop6213]

Thanks. Managed to do it though I don’t speak Hindi 😎

[@GyanOnTube]

Thank you.. great work

[@anupamaashokahirwar4175]

Sir kya aap computer 🖥️ Course me Full video bna skte h ya Couching de skte Hain

[@GyanOnTube]

Aapko kya excel ya advance excel ki coaching chaiye

[@GURDEEPSINGH-xl1wv]

EXCELLENT Sir kindly explain on custom column

[@GyanOnTube]

Sure will prepare another video on that

[@mohansinngh3225]

Sir hum agar connection ki jagah pehle hi table waala option select karte to bhi kya yeh data Excel mein load ho jaata

[@GyanOnTube]

Hanji bilkul ho payega

[@rajrajsha3484]

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...

[@GyanOnTube]

Yes you can definitely..you can merge append with the help of query editor

[@mazharul661]

It works, thank you (Y)

[@GyanOnTube]

Thank you so much

[@bestforyou2177]

Good work bro🎉

[@GyanOnTube]

Thank you so much

[@SanviPatil2019]

Nice

[@GyanOnTube]

Thank you so much

[@saurabh17sharma68]

Sir nice video Ye 2007 excel me chal jaayega sir

[@GyanOnTube]

Nhi ...2007 mein power query ka option nhi hota

[@saurabh17sharma68]

@@GyanOnTube ok sir

[@yuktabitla6363]

How to get filter if i filter in one sheet automatically same need to be filter in existing sheet

[@GyanOnTube]

We have that option as well

[@ManishGupta-un6es]

multiple workbook mein similar data ho to single workbook mein append kaise kare?

[@GyanOnTube]

Same option se

[@kumarpradeep8423]

nice

[@GyanOnTube]

Thank you so much..fo not forget to share this video

[@namratamistry7289]

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

[@GyanOnTube]

You can create through pivot as well

[@namratamistry7289]

@@GyanOnTube how? Can you guide me?

[@GyanOnTube]

I already have video on that topic , please check in my channel

[@hitendrasingh1087]

Thank You

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@munsifkhan7794]

sir can we bring data with format

[@GyanOnTube]

Yes

[@onlyexcel493]

It's magic ETL Tools..

[@GyanOnTube]

Very true..

[@ayazksoomro]

18 part is missing

[@GurvinderSingh-yw3qd]

hlo sir append kerne per three or more table wala option nh aa rha pls help me with

[@GyanOnTube]

Usme aur options aata hai aap check karo

[@gajananjadhav4802]

excel 2019 me ye option nhi he kya

[@GyanOnTube]

Nhi only in office 365

[@tariqsiddiqui2256]

Sir get data ka option excel 2010 main nhu araha kahn hota hy

[@GyanOnTube]

Aapko aapna office 365 mein upload karna hoga

[@jagadishreddyt2915]

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

[@GyanOnTube]

It will definitely reflect..you just need to refresh your consolidated file

[@anupamaashokahirwar4175]

Or Excel spreadsheet me Full course provide krwa skte Hain

[@GyanOnTube]

Aap mere channel mein dekho excel related bahut se course available hai

[@anupamaashokahirwar4175]

@@GyanOnTube Uska 🔗 link de sakte h aap

[@anupamaashokahirwar4175]

@@GyanOnTube Or sir agar AAP Digital marketing sikha skte Hain to btayiga jaroor Language Hindi hai

[@GyanOnTube]

@@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

[@SanviPatil2019]

super

[@GyanOnTube]

Thank you so much..😊

[@khalidmajeed2886]

sir when we add new sheet in it.how we will do it

[@GyanOnTube]

Just apply same steps

[@WajidKhan-om6hw]

Sir agar formats same na ho to kese merge karenge

[@GyanOnTube]

Tab to aapko manually hi karna hoga

[@WajidKhan-om6hw]

Sir agar bahut sare columns ho to manually karna bahut mushkil hoga

[@GyanOnTube]

To aap usko standardized kar sakte ho..for first time then you can apply merge Query

[@RIPONBHUIYAN-kr2oi]

How to mobile?

[@GyanOnTube]

Sorry

[@RahulRoy-po9ct]

🙏

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@pankajknowledgeworld]

मुझे दिक्कत ये आ रही है जब दूसरी शीट में एंट्री karta हू तो master file a entry नहीं आ रही है क्या करू

[@GyanOnTube]

Reference create karo

[@pankajknowledgeworld]

@@GyanOnTube देखता हू जो options ढूंढ रहा हू वो reference करके होता है क्या. देखता हू जी

[@pankajknowledgeworld]

नहीं हुआ entry update.. Power Query main wo new entry update hi nahi show हो रही है.. इसलिए master file main updates नहीं हो रही है

[@user-jc1kz6li8i]

Load to option grey hai.

[@GyanOnTube]

Try complete step without skipping

[@nikhilanand5759]

Sir get data ka option nhi aa rha

[@GyanOnTube]

Its called transform query

[@Sallan991]

Bhai baki sb thik ho gya but date ka format change ho gya sb ka

[@GyanOnTube]

Have you done any thing additional

[@vanitashetty1923]

I had to merge 172 tabs into 1 sheet..it ran out of memory

[@GyanOnTube]

What is your system ram

[@Siddthetraveller]

Get data option he nhi mil rha sir ji😅

[@GyanOnTube]

Kya aap office 365 use karte hain

[@Siddthetraveller]

Okey ji thanks u

[@GyanOnTube]

@Siddthetraveller np

[@addicted2oreos]

2 minutes in and I'm still trying to figure out if this vid is in English or not 🤣

[@GyanOnTube]

😊

[@karansadotra6388]

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 [e-mail]

[@GyanOnTube]

Aap mere power bi ki series dekh sakte ho usme saare excel files hai..