HOW TO SPLIT DATA FROM SUMMARY SHEET TO MULTIPLE SHEETS| LINK EVERY SHEET TO A MASTER SHEET IN EXCEL
HTML-код
- Опубликовано: 5 июл 2021
- SUMMARY SHEET SE DATA KO ALAG ALAG SHEET PAR LEKAR JANA USING INDIRECT FUNCTION (MIND BLOWING CONCEPT)
INDIRECT FUNCTION (PART-9)
LEARN - HOW TO SPLIT DATA FROM SUMMARY SHEET TO MULTIPLE SHEETS
-LINK EVERY SHEET TO A MASTER SHEET IN EXCEL
DOWNLOAD PRACTICE FILE: drive.google.com/file/d/1CW2-...
Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World.
SUBSCRIBE TO MY CHANNEL 👉 ruclips.net/channel/UC8sTJeRL...
#indirectfunction
#shivameducationworld
#mission1ksubsribers
Doston aap video ko pura dekhiyega aur achchi lage to ise like kijiyega share kijiyega, agar aapka koi sawal hai to aap mujhe comment bhi kar sakte hain ,main aapke comment ka reply dene ki poori koshish karunga.
PLEASE SUPPORT 🙏 ME FRIENDS BY LIKE 👍 AND SHARE aur SUBSCRIBE KARNA NA BHOOLE.(❁´◡`❁)
Thank You so much.
---------------------------------------------------------------------------------
About this channel-
Doston is channel me aapko office me work karne se sambandhit poori jaankari milegi,doston office me kaam karne ke liye ms excel aur ms word bahut jaroori hota hai,students ko bhi ms office ki bahut jaroorat hoti hai,doston is channel me aapko ms excel aur ms word aur computer se judi saari knowledge ke videos free me dekhne ko regular milte rahenge,yadi aap regular saare videos ko dekhenge to aap computer me perfect ho jayenge,doston main aapko ms excel me basic se lekar advance saari jankaari is channel me doonga aur shortcut keys bhi batata chaloonga,doston ye channel aapko office work/data entry me perfect banata hai.Doston MIS REPORT ke liye bhi aapko is channel me saari jankaari mil jayegi.
Doston agar aapko mera channel pasand aata hai to jaroor subscribe kijiyega.
Thank you so much-------
----------------------------------------------------------
shivam education world,shivameducationworld,summary sheet se data alag sheets par kaise lekar jayen,how to take data from summary sheet to different sheets,how to spread data into multiple sheets,how to link multiple workbooks in excel,how to automatically transfer and save data from one sheet to another,how to create multiple workbooks with sumarry sheet,split data into multiple sheets,how to split data into multiple sheets,how to link everywork sheet to a master sheet
Your doing great work. Keep it up❤
Really great wrok and combination designed. Appreciate your inspiration! 👍🏻
Very nice
🎉❤❤❤❤❤❤❤
Derar Shivam brother,
Thanks for nice explain & formula.
Use of area or branch more, so we used ur formula, but I've two category data in main/ summary sheet, want to find/ choose only one category data,
We use like these
Use of area- code
Mill- 800
Mill-700
Furnace 700
Furnace-800
Hopeful ur nice feedback.
Borhan/Bangladesh
🙏
Dynamic indirect good sir concept clear
Thank U
Zabardast sir 100% Pure content
HI Shivam, IT is very informative video, very easy to understand. Thank you for the amazing work. I have a question. How to add another city name in summary sheet ? will the new sheet open for the newly added city ?
Extraordinary Technique bro
Thank u
The video is awesome very nice thanks for making you are the best...👍👍
Thank U
Thanks sir 👍
Wow amazing concept👏
Very useful formula .. neatly explained ..
Thank you..
Glad you liked it
Well explained, Appreciated. nothing find this research else where. thanks and regard.
Thank U so much
Excellent bro....👌👌👌
This is something next level , sir , Thank you so much
Glad U like it
Nice video. U will get the subscribers as desired. Go on uploading videos.
Thank u so much
Sir main sheet sa dosari sheets to pivot table sa bhi extract ho sakti han.
Brriliant , thanks to share
Thank U
very unique...thanks
Most Welcome
Very good research 👍👍
Thank U 🙏
Little confusing but worth learning 👍
keep practicing my friend 👍
nice..master sheet main new branch add karne par uski seperate sheet automatically ban jayegi..??? with entries updated..???
Thankyou sir
Nice video sir , thank you sir , thank you , nice nice nice video.
Thank U
Valuable❤️
Thank U
Awesome video 👍👍
Thank u
sir kia hum is ko pivot table kaaay zariaay ker saktaaay haaay bagair kisi bhi formula ko istimaaal kiayyy
It was not less than rocket science. Most surprising!
Thank U
Thank you...the video and your explanation is very much appreciated. But for me it shows that there is not enough space to open this file...wt to do..pls reply
Appreciation
Thank U
Please explain the Menu Selection and others a bit slowly
It can be done using advance filter too, pls work on auto update advance filter and share the link pls
Awsome
Thank U
Khya name(AGRA) ki jagah numbers (12,15,74) kar sakte hai
345-b,345 b keshavpura keshavpura 4 kota 578hjkk 345ghjk M Se only 345 - b, keshavpura 4, ko alag colm m Lena ho to kya kre
Dear Sir
Please replace name AGRA,delhi in place of Numeric Number ie 80,90 sugest the formula
Support me friends 👍 and subscribe to my channel
#mission1ksubscriber✅
Sir data sir one sheets par show ho raha multiple sheets par data show nhi ho raha hai
Sar k Upar se gaya ...sar k andar daalne k liye practice karni padegi..😅
Thoda easy aur zoom mein karke dikhaye
Nice
Thank U
@@shivameducationworld एक बात ये बताओ जो फ्रीलांस पर एक्सेल में काम मिल ता है ये सही बात है क्या ।
Sir interview series lekar aye 😀😀😀😀
Ji Bilkul
@@shivameducationworld sir u have vast knowledge of excel... appreciate ur efforts... god bless u sir😊
@@factsnexts2720 Thank U
Hi bhai Excel ka ek problem hai
Sir formula not working.its very useful for me but am unable to do
SIR MERI WORKBOOK ME TO HI NAHI RAHA YE
Appreciate valuable
Thank U
Picture not clean