The Easiest Way - Master Sheet to Multiple Sheet Automatically in excel

The Easiest Way - Master Sheet to Multiple Sheet in excel. Excel me dosto master sheet se data multiple sheet me automatically kaise transfer karenge ye is video me main detail me bataya hai. bilkul aasan tarika maine bataya hai jis se koi bhi excel beginner badi aasani se master sheet ka data multiple sheets me dynamically transfer kar payega filter formula ka use kar ke.
in this video you will learn how to transfer data from master sheet to multiple sheet in microsoft excel using filter formula in hindi and Filter Formula Available in Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
#datatransfer
#exceltutorial
#excel
#2023
#DeepakEduWorld
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
Tags:deepak eduworld,master sheet to multiple sheet,transfer data in excel,microsoft excel,excel,excel tutorial,excel tips,transfer data,pivot table

Пікірлер: 157

  • @Shubh9898
    @Shubh9898 Жыл бұрын

    Sir aapke tarah pure youtube pr koi nhi smjhane vala you are my favorite teacher sir 🙏🙏

  • @DeepakEduWorld

    @DeepakEduWorld

    Жыл бұрын

    Thanks subham 😊

  • @parimalpatel4827

    @parimalpatel4827

    Жыл бұрын

    True

  • @nigdukabeta

    @nigdukabeta

    Жыл бұрын

    Excellent

  • @maheshsaini3458

    @maheshsaini3458

    Жыл бұрын

    Right bro 👍👍

  • @gyankeyboardyt
    @gyankeyboardyt Жыл бұрын

    Thanks❤❤

  • @prahladsharma9749
    @prahladsharma9749 Жыл бұрын

    Sir ji ap great ho apki information humesha gazab ki hoti hi...🙏🙏🙏

  • @gyankeyboardyt
    @gyankeyboardyt Жыл бұрын

    Gajab sikhate hain sir

  • @baharali7429
    @baharali7429 Жыл бұрын

    Very informative and helpful video. THANKS SIR

  • @tallypointaccountingclasse7456
    @tallypointaccountingclasse7456 Жыл бұрын

    shandar, Thanks Sir ...

  • @tallypointaccountingclasse7456
    @tallypointaccountingclasse7456 Жыл бұрын

    all time suggers my students ... watch your youtube chanal for great knowledge .. Thanks.

  • @rakeshnaidi9417
    @rakeshnaidi941711 ай бұрын

    Super depak ji

  • @abishekkumar7692
    @abishekkumar7692 Жыл бұрын

    Good information for future 👍

  • @beeharryanand6542
    @beeharryanand65428 ай бұрын

    Thanks a lot bro. Your videos helping me a lot. I am from Mauritius. Now i am becoming so easy with exel thanks to you. God Bless. If ever you come to mauritius someday plz let me know.

  • @rakeshnaidi9417
    @rakeshnaidi9417 Жыл бұрын

    Valuable Dosth super Tq

  • @ravimotivationquotes9827
    @ravimotivationquotes9827 Жыл бұрын

    Very good sir ji thank you so much

  • @pradipsingh2736
    @pradipsingh2736 Жыл бұрын

    SIR YOU ARE SIMPLE BEST

  • @niteshbhatt2703
    @niteshbhatt2703 Жыл бұрын

    Awesome Video Sir...

  • @harikrishankhati
    @harikrishankhati Жыл бұрын

    दीपक भाई आपकी हर प्रस्तुति बहुत ही अच्छी है । मैं आपके सभी वीडियो देखता हूँ ।मैं एक अध्यापक हूँ पर आप तो गुरु के गुरु है ।

  • @harishnagar4482
    @harishnagar4482 Жыл бұрын

    Excellent Sir Ji 👌

  • @sayansen6293
    @sayansen6293 Жыл бұрын

    You are the best

  • @gsincubatormaharashtra3967
    @gsincubatormaharashtra3967 Жыл бұрын

    Excellent sir 👌

  • @110Makram
    @110Makram Жыл бұрын

    Excellent trick,thanks for uploading such useful video.

  • @DeepakEduWorld

    @DeepakEduWorld

    Жыл бұрын

    Thanks akram g

  • @manojkulkarni6749
    @manojkulkarni6749 Жыл бұрын

    Great Sir 👍

  • @SaurabhSharma-ry8iz
    @SaurabhSharma-ry8iz Жыл бұрын

    Nice great video sir

  • @maheshsaini3458
    @maheshsaini3458 Жыл бұрын

    Very nice sir 👍

  • @sangeetabhatnagar738
    @sangeetabhatnagar7383 ай бұрын

    Excellent teaching

  • @AmbatipudiNarendra
    @AmbatipudiNarendra Жыл бұрын

    Nice. Thanks

  • @aamiralishaikh
    @aamiralishaikh Жыл бұрын

    Thanks sir ❤️

  • @vikasvisvkarma1102
    @vikasvisvkarma1102 Жыл бұрын

    Superb sir...🙏🙏

  • @DeepakEduWorld

    @DeepakEduWorld

    Жыл бұрын

    Thanks vikas

  • @sewingsolution7230
    @sewingsolution7230 Жыл бұрын

    Thank you ❤️sir

  • @hanumandas778
    @hanumandas77811 ай бұрын

    ❤ nice Job

  • @bkhudkhudia
    @bkhudkhudia Жыл бұрын

    अब इस वीडियो से मैं मेरी weekly सप्लाय को Datewise अलग कर के देख सकता हूँ. आपका बहुत बहुत धन्यवाद 🙏

  • @DeepakEduWorld

    @DeepakEduWorld

    Жыл бұрын

    🙏

  • @atikrashidshaikh2440
    @atikrashidshaikh2440 Жыл бұрын

    Superb sir

  • @MD-sk8vw
    @MD-sk8vw Жыл бұрын

  • @sujit1920
    @sujit1920 Жыл бұрын

    ❤ nice 👍

  • @altafhusainansari4282
    @altafhusainansari4282 Жыл бұрын

    Very Interesting video. पूरा अच्छे से आप ने समझाया है। और अच्छे से समझ भी गए है। आप के इसी बहुत सारी एक्सेल ट्रिप से मेने बहुत ही शीट तैयार किया है। इस में शेयर नही होता है। नही तो आप को में भेजता मेरे बनाए हुवे शीट। में आप को दिल से धन्यवाद करता हु जो आप इतने आसान से भाषा में समझाते है।

  • @DeepakEduWorld

    @DeepakEduWorld

    Жыл бұрын

    Mughe bahut khushi hoti hai ALTAFHUSAIN G ki mere videos se aap aasani se seekh paate hain and apke kaam bhi aate hain 😍

  • @altafhusainansari4282

    @altafhusainansari4282

    Жыл бұрын

    धन्यवाद दीपक जी। 👍🙏 परंतु एक बात है। दीपक जी हमारे ऑफिस में एमएस ऑफिस २०२१ नही है। इसी वजह से हम फिल्टर फंक्शन का उपयोग नहीं कर पाते है। नही तो ये फंक्शन मेरे लिए बहुत अच्छा साबित होता डाटा एक्सट्रैक्ट करने में। फिर भी में इसे वीडियो को डाउनलोड कर लेता हु कभी एमएस ऑफिस २०२१ अपलोड किया जाए तो काम आएगा आगे चल।

  • @darshitchavda8264
    @darshitchavda8264 Жыл бұрын

    Terrific

  • @naughtyvibs1
    @naughtyvibs1 Жыл бұрын

    Nice 👍

  • @shaikhmohmad3622
    @shaikhmohmad3622 Жыл бұрын

    Thanks dost

  • @kashifeduworld
    @kashifeduworld Жыл бұрын

    Masha Allah Sir So Beautiful Video Keep it up💗💗💗

  • @DeepakEduWorld

    @DeepakEduWorld

    Жыл бұрын

    Thanks kashif g

  • @kishansinghshekhawat8634
    @kishansinghshekhawat8634 Жыл бұрын

    Superb explanation good job deepak

  • @DeepakEduWorld

    @DeepakEduWorld

    Жыл бұрын

    Thanks kishan g

  • @govindgupta9544
    @govindgupta9544 Жыл бұрын

    Super sir

  • @HiteshSharma-ti1km
    @HiteshSharma-ti1km Жыл бұрын

    Good 👍

  • @UsamaFayyazCreations
    @UsamaFayyazCreations Жыл бұрын

    Great sir, love from Pakistan🇵🇰

  • @pknewknowledge6629
    @pknewknowledge6629 Жыл бұрын

    Happy holi sir

  • @khemacharya8611
    @khemacharya861110 ай бұрын

    Very nice video sir but can you give a way to filter separate data of ABC business cash and online seat in the video you made? Like with ABC Business Cash and with ABC Business Online as well as Auto Filter

  • @RiteshKumar-bh4ki
    @RiteshKumar-bh4ki Жыл бұрын

    Sir I always watch your videos i like all videos Sir I have a query may you please make a video about GST in Excel full tutorial

  • @dhirajmahara5578
    @dhirajmahara5578 Жыл бұрын

    Best

  • @JackAJ
    @JackAJ Жыл бұрын

    Sir Protected sheets me Marco Run kaise hoga?... Sir please help me and please make video on it ❤❤❤🙏🙏🙏

  • @factsaslam3651
    @factsaslam3651 Жыл бұрын

    Practice file v add kr diya kijiye description me...by thank you

  • @Rutvikpatil12345
    @Rutvikpatil1234511 ай бұрын

    दिपक सरजी, आपने जो सिखाया वो बहुत बढीयॉं है, पर मेरे कॉंप्युटर में Excel Version 2007 हे, तो Filter Formula इस Version मै नहीं हैं, तो इसे कैसे Use करे, कुछ Solutions बताईये 🌹🙏

  • @2010royraju
    @2010royraju11 ай бұрын

    sir complete tally course ek video me dijiye bahut upkar hoga

  • @sarfraz.ahmedshaan3297
    @sarfraz.ahmedshaan3297 Жыл бұрын

    Sir isi tarah 10 different different Excel ko ek master sheet kaise banaye

  • @rakeshnaidi9417
    @rakeshnaidi941711 ай бұрын

    Iam working inventory related or sales related excel files office use

  • @Shubh9898
    @Shubh9898 Жыл бұрын

    Sir aap se ek request hai aap tallyprime ki bhi videos banao sir ji..

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki Жыл бұрын

    Sir plz practice file dia kro plz

  • @azrairfan9898
    @azrairfan9898 Жыл бұрын

    Very nice and informative. Thanks. I have a question. How I can insert data form picture/pdf to excel 2016 in table form. plz answer.

  • @satishcomputersportsedu.9440
    @satishcomputersportsedu.9440 Жыл бұрын

    माइंड ब्लोइंग सर 👏👏👏

  • @DeepakEduWorld

    @DeepakEduWorld

    Жыл бұрын

    Thanks satish 😊

  • @ankurjain1513
    @ankurjain151311 ай бұрын

    sir cab we use finletr formula with multiple match condition like mnatch data in 2 colums if same then data import in destination table

  • @AnandStudio8487
    @AnandStudio8487 Жыл бұрын

    Super sir Jay hind sir mai Deepak kumar surat se apka help chahiye sir

  • @DeepakEduWorld

    @DeepakEduWorld

    Жыл бұрын

    Jai hind deepak g

  • @DeepakEduWorld

    @DeepakEduWorld

    Жыл бұрын

    Kahiye kya help chahiye

  • @BalvirSingh-qs9kz
    @BalvirSingh-qs9kz9 ай бұрын

    Sir, ek sath adhik sheets bana sake. Formula batayen.

  • @shivkumar-mh5gx
    @shivkumar-mh5gx Жыл бұрын

    Aapne kaha tha ki a to z excel channel par aur tab ki videos aayegi. Please us channel pe bhi video daalo.

  • @DeepakEduWorld

    @DeepakEduWorld

    Жыл бұрын

    Hanji shiv…. Bas ab regular videos aane vale hain

  • @mukeshsingh3614
    @mukeshsingh3614 Жыл бұрын

    Please sir aap advance Excel me full video banaiye 🙏🙏🙏🙏

  • @kingofvasai
    @kingofvasai Жыл бұрын

    Make POS in excel

  • @rakeshnaidi9417
    @rakeshnaidi9417 Жыл бұрын

    I will use this but friend he asking me filter also same information used take same time

  • @usmankhan-uj3uw
    @usmankhan-uj3uw Жыл бұрын

    How to prepare product price history and add new price

  • @rakeshnaidi9417
    @rakeshnaidi9417 Жыл бұрын

    Use filter same information

  • @aryankumar-gx7pw
    @aryankumar-gx7pw11 ай бұрын

    Sir Master Sheet Se Multiple Sheet Kaise Banaye

  • @shekharroy703
    @shekharroy7036 ай бұрын

    मुझे excel शुरु से सीखना है।

  • @abhishekrajbhar2233
    @abhishekrajbhar2233 Жыл бұрын

    Sir apke a to z excel chainal par menu video nhi a rahi h please video banaeye

  • @RohitTiwariLifeChanal
    @RohitTiwariLifeChanal Жыл бұрын

    Sr muje dictionary banani hai b Good गुड अच्छा Is type kese banaye muje jaruri hai

  • @mdabdullah2429
    @mdabdullah2429 Жыл бұрын

    Sir Marco sy karoto a kam karyga?

  • @trilokbist1881
    @trilokbist1881 Жыл бұрын

    Really very useful video, can you explain that how can we totalling each sheet with same trick.

  • @Parv2521
    @Parv2521 Жыл бұрын

    Sir, how to creat find all option using formula to search a part of text in sheet

  • @Ravindra31sd
    @Ravindra31sd Жыл бұрын

    Mai Kab se request Kar Raha hu sir ki insert tab excel ka complicit video banaiye sir

  • @2010royraju
    @2010royraju11 ай бұрын

    bahut kuch jan rahi hu

  • @prabhakarpawar573
    @prabhakarpawar573 Жыл бұрын

    Sir, excel 2007 or 2010 me file ka qr code banana hai. Kaise bana sakenge plz guide me

  • @sushahs9656
    @sushahs9656 Жыл бұрын

    Filterarray and filterxml formula both have the same function ? Here filter array can’t show us

  • @rakeshpal500
    @rakeshpal500 Жыл бұрын

    Sir, kya master file me agar image bhi insert to multiple sheet and multiple workbook me realtime update ho sakta hai.please advice how to do. Thanks very much.

  • @sumeetkedar9214
    @sumeetkedar92144 ай бұрын

    200 sellers honge to manually sheets add karne padegi kya ?

  • @zafarIqbal-rk4tp
    @zafarIqbal-rk4tp9 ай бұрын

    Need one sheet for all customer wise order # and total amount

  • @adilhumayun125
    @adilhumayun12511 ай бұрын

    Sir how can I apply subtotal formula in this

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki Жыл бұрын

    Sir plz send link practice file plz plz plz plz plz i very need

  • @princepujara4459
    @princepujara44593 ай бұрын

    Please help me to get office 365 or excle 2021 version as filtwr formula is not available in earlier version

  • @rvikram1192
    @rvikram11922 ай бұрын

    Ye kaam automatically 500+ sheet create karna hai to kaise hoga

  • @muhibullah5309
    @muhibullah53097 ай бұрын

    If Callum different mastered sheet and other then what will we do an that case

  • @intrestedanand3887
    @intrestedanand3887 Жыл бұрын

    Multiple sheet to master sheet karni hai hai Mere office me 50 sheet me kaam hota hai same formate me finally master sheet banani hoti hai ek ek kar k

  • @PawanKumar-xb1dk
    @PawanKumar-xb1dk Жыл бұрын

    Sir hamse filter ka formula apply nahi ho raha h batao sir please

  • @rpyadav5026
    @rpyadav5026 Жыл бұрын

    Sir, hamare computer me filter formula nahin ata hai. Kaise activate hoga.

  • @pawanjangra9353
    @pawanjangra9353 Жыл бұрын

    Sir ager ak file ka data 3-4 file me ak sath update kese kre or iske liye kuch btao sir me bhut presan hu mujhe ak file ka kaam copy paste krke krna pdta h or isme Mera bhut time kharab ho jata h please sir help me 🙏

  • @bestcakesdesign
    @bestcakesdesign Жыл бұрын

    Summary sheet to multiple sheet kese

  • @ajay7512
    @ajay7512 Жыл бұрын

    What if we want select columns to display on different sheets & not all columns

  • @gaganwadhwafreelancer

    @gaganwadhwafreelancer

    5 ай бұрын

    Sir You can Use outside this filter Formula Choose col Formula and add which column number you want to show in that sheet. Hope So Your Query clear.

  • @jeetuchillal1444
    @jeetuchillal1444 Жыл бұрын

    Sir, Filter option is not available in Excel 2019 and using 2021 is not free I guess... henceforth please make sure your learning should be consider large group which is using excel 2019 🙏

  • @reema8635
    @reema8635 Жыл бұрын

    Sir filter nhi aa rha option FILTER XML aa rha usse ho nhi rha

  • @hsbdailyshow3197
    @hsbdailyshow31978 ай бұрын

    @deepakeduworld maine try kia lakin filter function ki jaga Filterxml arha hai aur filter ka koi option nai arha 2019 Ms excel

  • @heeralalkumawat2132
    @heeralalkumawat2132 Жыл бұрын

    Isse or acha to pivot table se ho jayega

  • @Music_Lover_Shantanu

    @Music_Lover_Shantanu

    Жыл бұрын

    Are vai wo to hum jante hain, lekin apne socha kya aaj kuch naya sekhne ko mila.

  • @user-ly7jg4zw5p
    @user-ly7jg4zw5p5 ай бұрын

    Master data to multiple sheet is okay, can we do vice versa?

  • @stechonline7940
    @stechonline7940 Жыл бұрын

    aawaj nahi hai sir video me

  • @rakeshnaidi9417
    @rakeshnaidi9417 Жыл бұрын

    What is use this way

  • @sumansagar5976
    @sumansagar5976 Жыл бұрын

    सर मुझे एमआईएस रिपोर्ट बनाना सीखना है कैसे शिखेंगे? 🙏

  • @abuildersrenovation7624
    @abuildersrenovation7624 Жыл бұрын

    Not working for lage size data

  • @nareshdogra3180
    @nareshdogra31808 ай бұрын

    Filter wala formula invalid bta rha hai

  • @myknowledgebook815
    @myknowledgebook81510 ай бұрын

    Ye filter ka furmula kis excel me ayega ?