Filter Data To Another Sheet In Excel | Using Advanced Filter in Hindi
HTML-код
- Опубликовано: 11 сен 2024
- Filter Data To Another Sheet In Excel Hindi 2021 - How To Use Filter in Microsoft Excel
How can you send Excel 2010 2013 2016 2007 2019 Filtered data to a different sheet, without a macro, and no copying and pasting? Use This Amazing feature of advanced filter and you can see how To Extract excel data from one sheet to another sheet using advanced filter. you can't only copy filtered data to the active sheet you can also copy [ extract,send ] filter data to another [ different ] worksheet
excel advanced filter copy to another sheet
excel copy filtered data to another sheet automatically
excel filter data and copy to another sheet Without vba
excel dynamic filter to new sheet
dynamic advanced filter excel
ADVANCED FILTER VIDEOS SERIES:
1. Advanced Filter in excel in Hindi - Auto VS Advanced filter
• Advanced Filter in exc...
2. Filter Data To Another Sheet In Excel | Using Advanced Filter in Hindi
• Filter Data To Another...
3. How To Filter Data For Blank Cells In Excel | Using Advanced Filter In Hindi
• How To Filter Data For...
4. Advanced filter unique records only in hindi
• Advanced Filter In Exc...
5. Make ADVANCED FILTER Dynamic || Auto Updating || Filter To Another Sheet
• How To Make ADVANCED F...
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
MS Word Complete Course : • Microsoft Word A to Z ...
MS PowerPoint Complete Course : • MS Power Point Tutoria...
#Filter
#AdvancedFilter
#Excel
#DeepakEduWorld
#2021
#HowToUse
#ExcelTutorial
#LearnExcel
#Excel_online_course
#Microsoft_Excel
#How_To
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
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
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld
Kul milakar baat ye yai ki Aapke jaisa sikhane wala teacher mil jaaye toh koi bhi subject bhaari nhi hai... 💓Dil se Salute sir aapki teaching ko👌👌👌👌👌👌
thanks sir bhut ache se clear ho gya mera.
Sir,I'm thankful to you from the core of my heart.I have learnt a lot from your videos and still learning.God bless you.
You are very good teacher.
Thank you very much
Sir, what comment should I do? I have no words to praise. Similarly, I am very ill fated to see such a marvelous video after 5 years of it's posting. Missed a lot of energy so far. Atleast now I have seen 🙏🙏🙏💐💐💐 Thank you so much ji, with lot of respect 💐💐💐
Your teaching process is excellent sir.Thnkq so much.
दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* ruclips.net/video/Xkq0-xXAj48/видео.html
*Complete Powerpoint Tutorial :* ruclips.net/video/OekrBhNybP0/видео.html
*Xlookup Complete Tutorial :* ruclips.net/video/0LjfRVD7srU/видео.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* ruclips.net/video/C9y53fedo04/видео.html
*Office Work in Excel :* ruclips.net/video/PT8D1qQwe1k/видео.html
Really good video on basics of using Advance Filter with multi criteria. Thank you. We can set the criteria anywhere, it is not mandatory to set it the same sheet where the master data is. I tried and it worked. We can also use it if our criteria is dynamic but for that we need to apply MACRO. I request you to please make one tutorial on that also when we change our criteria dynamically in the set criteria range the filtered data should automatically extracted to another sheet without doing any repeatation. I tried to do it but I need it for more than one criteria.
One of the most useful videos in Excel learning. Please let us know if the results can be changed by changing the criteria values manually in the master sheet. For example : if we select the criteria as Delhi, the results on the destination sheet will be for Delhi only, but if we change the criteria in that criteria range to Noida after getting the result, will the result be changing to Noida.
Your teaching is very good.
आपका समझाने का तरीका बहुत अच्छा है |
Thanks sir ji aap gyaan ke devta ho sir ji aap mahan guru ho sir ji
🙏🙏🙏🙏🙏🙏 thanks so much sir ji
Osm sir apke sikhana ka tarika bahut easy and useful h
Very nice Dipaksir 👌👌👌
बहुत अच्छा समझाया भाई धन्यवाद।
Thank you ....really very useful information... I always use your all tricks for my office works ...
very good and easily understanding video on advanced filter
Thank you so much sir... Aapki ye vedio mere liye bahut helpful rahi... Thank u so much
Really deepakji your work is very appreciable the way you teach is really awesome........
Hi Sir, Thank You very much, I have learned Ms excel from your vedios , your vedios will help to upcoming students of india,
Love u sir... aapka tarika bahut acha hai sir samjhane ka ty....
excellent
I hv become a fan of ur teaching style
दीपक भाई ....
बहुत बढ़िया ।
सब कुछ सही है ।
एक अलग प्रश्न है :-
मान लीजिए हमारे पास एक शीट 1 में 200 स्कूलों के अध्यापकों की Bio-data है हम चाहते है कि प्रत्येक स्कूल अलग अलग शीट में कॉपी हो जाएँ और शीट 1 से लिंक भी रहे तथा किसी भी शीट में correction करने से शीट 1 में update होता रहे ।
Boht hi behtreen videos hain. short and simple and so well explained. Thank you so much.
Very nice Sir, U r great teacher .
प्रिय दीपक जी आपका वीडियो बहुत अच्छा है
Apki video bohot helpful hoti hain
Thank u sir
Thanks sir
Baht Acha laga sir aap k vidio
Baht achhe se samjhate he sir
Superb formula sir 👍 ( also you just look a like Varun Dhawan )
sir you are good person i am follow your guide line sir .
आपकी वीडियो स्कूल में बहुत सहयोगी है, tnx
👍😊😊😊
बहुत ही अच्छा भाई ।
Sir apke jaisa world me aur logo ki need hai is world ko beautiful banane me
Very useful video thank you for your precious time for making it.......!
Love your way of teaching sir🙏💐
Ye to aapne bahot majedar chij batai sir, Maja aa gaya Thanx.
😊😊
Deepak ji,
Thanks for giving us smart excel using ideas as much you can....
Sir, i would like to request you pls tell me how to get variations from from two sheets data of same range of colomns and if any mismatch than result / diff of values showing in 3rd sheet of excel....
I again elaborate my ques...i.e
For accounting purpose i download my suppliers invoices details from GST portal and also export details from my system of that purchase,
Classified these two reports in excel as sheet 1 or 2..now there are main 6 col's i selected for verification from each sheet,
1 GSTIN
2 PARTY NAME
3 TAXABLE VALUE
4 IGST
5 CGST
6 SGST
Now let's say GSTIN is the common figure which mostly is the same in both sheet, so on that consider as a common based id if any missmatch in their next four values i.e TAXABLE VALUE, IGST, CGST and SGST than it will be shown as Variation results between two sheets in Next 3rd Sheet...
If we can do with the help of your valuable suggestion then please upload this in your channel
You may call me feelfree any time in day my contact 8847322325, 8283088958
Thanks, DINESH SHARMA
Im from Pakistan sir. your videos are best and easy to learn excel.
Wow sir your teaching style is awesome sir..
thanks sir your teaching style superb! i am learning to you lots of difficult work by your teaching very easy! i love u sir..... bht km teacher hote hein ap jaise jo mushkil km ko bhe asani se samjha dein. me ne bht kuch sikha ha ap se or sikh rha hun... khush rhen hamesha apka fan Najam khan from pakistan karachi
Thank u very much. Learned a lot.
बहुत ही useful व्हिडिओ.. धन्यवाद सरजी..
एक question हैं..
जीस शीट पर हमने डाटा फिल्टर किया है उसको लिंक कैसे करेंगे? ताकी ऑटोमैटिक डाटा फिल्टर होके दूसरे शीट पे मिल जाएगा? प्लीज answer..
Thank you so much sir... How much this video help me it's unexplainable.
VERY USEFUL AND INTERESTING KNOWLEDGE
Excellent trick sir ji . I liked them
Amazing video Bro. 😀😄
Sir good morning m app ki video say kafi jyada learn krta hu acha lagta h app ka tarika sir but sir allha app ko slamat rake
Its too good and very simple to learn easily..thx for this video
Very nice way to teach the formulas thank you sir
सर बहुत ही उपयोगी वीडियो बनाया है। इसके लिए बहुत बहुत धन्यवाद। सर इस प्रकार से फिल्टर किया गया डेटा अपनी मूल शीट से कनेक्ट होगा। इसे स्वतंत्र रूप से सेव कैसे करेंगे।
बहुत अच्छे से समझाते हैं सर आप एक चीज समझाये सर जिनके पास यूनिक आईडी हो वह filter होके another sheet पे pest हो जाए।
Deepak eduworld is no 1 and mr Deepak is great teacher.
So good sir, apki sob class very useful.
Thank you very much for all of your Videos.......
Clear, concise explanation..great job, Sir..
ruclips.net/video/eqGcR0zKOSM/видео.html
Fantastic. There is no one like u as far as explanation is concerned
Very nice lecture and good skill of teachinh
Very nice sir Thank you so much
Good morning & teaching,
Thanks,
Thank you so much , your videos are very useful but I have a problem how can filter the DATA from two sheets to one separate sheet if you make it it will be your helpful for us I have a peromblem to work in one Refresh buttan. thank you very much
Thank you so much Excellent way of explaining
I have no words for you. Very useful
Fantastic video sir
Is very useful
Bht bht shukurya ji asa mazed video bejain
Very nice videos. Specially your teaching style is so good. It's easy to understand who they are not well in English. ,,😙🤗🤗🤗😀😀😊😃😄
SIR YE BAHUT ACCHA LAHA
Excellent very well explained thanks for nice sharing .
Really u are teach well..i follow u
thank you for uploading this video. describing with very easy language.👌👌👌
🤗
Sir. Good work. Very clearly and simply explained
Thank u sir.u are number1.beyond words ur hard work and kindness.
😊
Deepak sir I m a great fan of yours and yours teaching method.sir if possible pls make videos on tally and photo shop for this I shall be so grateful to you. Thanks in advance
well done Sir. .I like you way of explaining. .I got it clearly.
thanks
Dear deepak Ji
Thanku for all these formulas these are sooooo helpful also pls tell me how v can sum A3 TO BZ3 EXPECT E3,K3,O3 LIKE MANY MORE CELLS
Okay.. U have to select the cells manully.. Put sum formula.. And click on the cells separated by commas...
Wah... sir .. kya gajab pdate ho... very well explanation...
Thank you. Very useful video
Very useful videos & channel for me
Thank you brother for uploading this useful video. Your way of teaching is excellent.
This is very useful for my job.
Thanks.
Visit my channel ruclips.net/user/c4ccoachingforcareers for advanced to advanced excel in hindi...
Thank you so much but ek problem he mera ki ese hi 10 sheet mese data filter karke sirf ek hi sheet pe sab data birth place wise aav jaye with micro bhi run karna he
Ovovovovovovovovogklkkpllbcbl9
You applied for the filter go and make the same and take care of this 🙂 and take it from you dear 😘😘😘😘 and Alphonso is 66
Type the ab of e is the first year you applied the same as the t a for filter t not well as well in our life 🧬 I will send yyyyyyy ty u yyyyyyy ty you applied yy yyyyyyy ty and yyyyyyy ty ty 6yyyyyyyyyyyyyu
Tttfzfiffffftttztsys and t is tS s 5
very useful and informative
Thank You Deepak Dada, I am looking from Bangladesh.
GREAT, BAHUT SAHI
THANKS
OM SAI RAM
Bah, khub bhalo.thank you sir.
Very nice video thankyou sir
Sir, aap ke videos bahut achhe hein, aapke samjhane kaa tarika bhi bahut achha hein. sir aap apni ms-excel ki practice ki soft copies downladable format bhi uplabhdh kara sakte hein. so we can use these videos with same process. Thanks & Regards, Pankaj Kumar, New Delhi
Excellent.. I. Like your voice modulation
फारच महत्वाची माही दिल्याबद्दल धन्यवाद
Sir AAP ka j ok ok bolna bohat zabar dast hai es ok ok kehny k Karan hi main es video Ko dekh pya nai to nahi dekhta
Nice Example ☺👌
Thanks dada, this video very helpful for me.
Bhai aap ko salam mera
Very helpful n comprehensive!!
Simple but useful..!!☺️
Sir you are genius
Thanks for uploading video
😊👍👍👍
Thanks Sir. Very Good Video
Very effective video, Nice video
😊
Nice teaching
Thanks Sir,
For your kind information.
Your videos are very helpful & valuable for us.
a lots of Thanks.
😊♥️♥️