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
Sir aapke tarah pure youtube pr koi nhi smjhane vala you are my favorite teacher sir 🙏🙏
@DeepakEduWorld
Жыл бұрын
Thanks subham 😊
@parimalpatel4827
Жыл бұрын
True
@nigdukabeta
Жыл бұрын
Excellent
@maheshsaini3458
Жыл бұрын
Right bro 👍👍
Thanks❤❤
Sir ji ap great ho apki information humesha gazab ki hoti hi...🙏🙏🙏
Gajab sikhate hain sir
Very informative and helpful video. THANKS SIR
shandar, Thanks Sir ...
all time suggers my students ... watch your youtube chanal for great knowledge .. Thanks.
Super depak ji
Good information for future 👍
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.
Valuable Dosth super Tq
Very good sir ji thank you so much
SIR YOU ARE SIMPLE BEST
Awesome Video Sir...
दीपक भाई आपकी हर प्रस्तुति बहुत ही अच्छी है । मैं आपके सभी वीडियो देखता हूँ ।मैं एक अध्यापक हूँ पर आप तो गुरु के गुरु है ।
Excellent Sir Ji 👌
You are the best
Excellent sir 👌
Excellent trick,thanks for uploading such useful video.
@DeepakEduWorld
Жыл бұрын
Thanks akram g
Great Sir 👍
Nice great video sir
Very nice sir 👍
Excellent teaching
Nice. Thanks
Thanks sir ❤️
Superb sir...🙏🙏
@DeepakEduWorld
Жыл бұрын
Thanks vikas
Thank you ❤️sir
❤ nice Job
अब इस वीडियो से मैं मेरी weekly सप्लाय को Datewise अलग कर के देख सकता हूँ. आपका बहुत बहुत धन्यवाद 🙏
@DeepakEduWorld
Жыл бұрын
🙏
Superb sir
❤
❤ nice 👍
Very Interesting video. पूरा अच्छे से आप ने समझाया है। और अच्छे से समझ भी गए है। आप के इसी बहुत सारी एक्सेल ट्रिप से मेने बहुत ही शीट तैयार किया है। इस में शेयर नही होता है। नही तो आप को में भेजता मेरे बनाए हुवे शीट। में आप को दिल से धन्यवाद करता हु जो आप इतने आसान से भाषा में समझाते है।
@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
Жыл бұрын
धन्यवाद दीपक जी। 👍🙏 परंतु एक बात है। दीपक जी हमारे ऑफिस में एमएस ऑफिस २०२१ नही है। इसी वजह से हम फिल्टर फंक्शन का उपयोग नहीं कर पाते है। नही तो ये फंक्शन मेरे लिए बहुत अच्छा साबित होता डाटा एक्सट्रैक्ट करने में। फिर भी में इसे वीडियो को डाउनलोड कर लेता हु कभी एमएस ऑफिस २०२१ अपलोड किया जाए तो काम आएगा आगे चल।
Terrific
Nice 👍
Thanks dost
Masha Allah Sir So Beautiful Video Keep it up💗💗💗
@DeepakEduWorld
Жыл бұрын
Thanks kashif g
Superb explanation good job deepak
@DeepakEduWorld
Жыл бұрын
Thanks kishan g
Super sir
Good 👍
Great sir, love from Pakistan🇵🇰
Happy holi sir
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
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
Best
Sir Protected sheets me Marco Run kaise hoga?... Sir please help me and please make video on it ❤❤❤🙏🙏🙏
Practice file v add kr diya kijiye description me...by thank you
दिपक सरजी, आपने जो सिखाया वो बहुत बढीयॉं है, पर मेरे कॉंप्युटर में Excel Version 2007 हे, तो Filter Formula इस Version मै नहीं हैं, तो इसे कैसे Use करे, कुछ Solutions बताईये 🌹🙏
sir complete tally course ek video me dijiye bahut upkar hoga
Sir isi tarah 10 different different Excel ko ek master sheet kaise banaye
Iam working inventory related or sales related excel files office use
Sir aap se ek request hai aap tallyprime ki bhi videos banao sir ji..
Sir plz practice file dia kro plz
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.
माइंड ब्लोइंग सर 👏👏👏
@DeepakEduWorld
Жыл бұрын
Thanks satish 😊
sir cab we use finletr formula with multiple match condition like mnatch data in 2 colums if same then data import in destination table
Super sir Jay hind sir mai Deepak kumar surat se apka help chahiye sir
@DeepakEduWorld
Жыл бұрын
Jai hind deepak g
@DeepakEduWorld
Жыл бұрын
Kahiye kya help chahiye
Sir, ek sath adhik sheets bana sake. Formula batayen.
Aapne kaha tha ki a to z excel channel par aur tab ki videos aayegi. Please us channel pe bhi video daalo.
@DeepakEduWorld
Жыл бұрын
Hanji shiv…. Bas ab regular videos aane vale hain
Please sir aap advance Excel me full video banaiye 🙏🙏🙏🙏
Make POS in excel
I will use this but friend he asking me filter also same information used take same time
How to prepare product price history and add new price
Use filter same information
Sir Master Sheet Se Multiple Sheet Kaise Banaye
मुझे excel शुरु से सीखना है।
Sir apke a to z excel chainal par menu video nhi a rahi h please video banaeye
Sr muje dictionary banani hai b Good गुड अच्छा Is type kese banaye muje jaruri hai
Sir Marco sy karoto a kam karyga?
Really very useful video, can you explain that how can we totalling each sheet with same trick.
Sir, how to creat find all option using formula to search a part of text in sheet
Mai Kab se request Kar Raha hu sir ki insert tab excel ka complicit video banaiye sir
bahut kuch jan rahi hu
Sir, excel 2007 or 2010 me file ka qr code banana hai. Kaise bana sakenge plz guide me
Filterarray and filterxml formula both have the same function ? Here filter array can’t show us
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.
200 sellers honge to manually sheets add karne padegi kya ?
Need one sheet for all customer wise order # and total amount
Sir how can I apply subtotal formula in this
Sir plz send link practice file plz plz plz plz plz i very need
Please help me to get office 365 or excle 2021 version as filtwr formula is not available in earlier version
Ye kaam automatically 500+ sheet create karna hai to kaise hoga
If Callum different mastered sheet and other then what will we do an that case
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
Sir hamse filter ka formula apply nahi ho raha h batao sir please
Sir, hamare computer me filter formula nahin ata hai. Kaise activate hoga.
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 🙏
Summary sheet to multiple sheet kese
What if we want select columns to display on different sheets & not all columns
@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.
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 🙏
Sir filter nhi aa rha option FILTER XML aa rha usse ho nhi rha
@deepakeduworld maine try kia lakin filter function ki jaga Filterxml arha hai aur filter ka koi option nai arha 2019 Ms excel
Isse or acha to pivot table se ho jayega
@Music_Lover_Shantanu
Жыл бұрын
Are vai wo to hum jante hain, lekin apne socha kya aaj kuch naya sekhne ko mila.
Master data to multiple sheet is okay, can we do vice versa?
aawaj nahi hai sir video me
What is use this way
सर मुझे एमआईएस रिपोर्ट बनाना सीखना है कैसे शिखेंगे? 🙏
Not working for lage size data
Filter wala formula invalid bta rha hai
Ye filter ka furmula kis excel me ayega ?