OMG 🔥 99% ये बिलकुल नहीं जानते - Transfer Data From Master Sheet to Multiple Sheet in Excel

OMG 🔥 99% ये बिलकुल नहीं जानते - Transfer Data From Master Sheet to Multiple Sheet in Excel 2022 in hindi
Dosto Excel me master sheet ka data automatically multiple sheets me transfer kaise kare ? sayad ye apko aata hoga aur iske liye aap formula, macro ya vba use karoge. kya bina vba, bina macro aur bina formula use kiye hum master sheet ka data automatically multiple sheets me transfer kara saktey hain ?
is video me maine btaya hai kaise aap pivot table ka use kar ke master sheet ko multiple sheets me split kar saktey ho wo bhi dynamically jo mostly excel users ko nhi pata so ye video kaafi informative hone vala hai aapke liye.
in this video you will learn how to transfer data from master sheet to multiple sheets automatically in excel without using vba, macro and formulas. you can easily split master sheet into multiple sheets using pivot table.
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Download Training File : bit.ly/3PwT7DB
#exceltips
#deepakeduworld
#Excel_online_course
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
transfer data in excel,microsoft excel,excel,excel tutorial,excel user,sheets,excel macros,excel tips,transfer data between worksheets in excel,excel data transfer between sheets,macro in excel,transfer data to another sheet automatically,transfer data one sheet to multiple sheets excell vba,transfer data,master sheet to multiple sheet automatically,deepak eduworld

[@09shirish]

Nice information, thanks Sirji !

[@girirajnagar7125]

Wow 😳 shandaar trick boss 👍🏻

[@irfanchauhan313]

Thank You very much for your constant support for the people. You are really helping us a lot. You have increased our knowledge. 🙏

[@ranasajidali9604]

Thank for your unique teaching style. (Lahore)

[@user-jo2st3zx4g]

very good excel concept , Thank you so much for video

[@shankariyer62]

Video was magical...thank you Sirji

[@manojkulkarni6749]

Really Knowledgeable video Thanks

[@manjit.sarania]

Sir amazing..I'm learning a lot from u..🙏🙏🙏

[@uditprajapatiofficialreal3972]

Super 😊😊 master class 🤗 dil se dhanyawad 🙏🚩 Jay shree Ram

[@mehachhajed5984]

Thankyou for such a thoughtful idea.

[@mohammadilyas2260]

Excellent زبردست

[@nakulanand2725]

Very useful video sir, agar hume multiple sheets me se ek master sheet banani h toh kaise karenge pls bataye?

[@gopikrishnavejella6309]

Sir excellent information to save time

[@excelkarnesehoga-kali9957]

Sir I appreciate your unique trick

[@baharali7429]

Excellent work thanks for your teaching very. Thanks

[@officialshanu3496]

Hyyy❤️

[@anapplemango9464]

Hello sir, it's too good, I really appreciate you, you have to right, I say again & again thanks a lot.

[@ihgamingfun6295]

Thankx 👍🏼👍🏼👈

[@ajaytondwalkar3266]

Superb Trick thanks

[@NCGyan22]

Bahut hi badhiya trick

[@AlokSingh-ri4ey]

Dhanyawad sir

[@muhammadharoon8631]

Proud on you sir g

[@motwanitvandroid2049]

!!! Thanks a lot ...☺️☺️

[@Moizfoodi]

Great sir jee…

[@shaileshgaud8589]

Dil se thanks 👍 Video Creator + People like me ! Who come to learn something new on KZbin.😇😇😇🙏

[@muhammadharoon8631]

I love with excel

[@officialshanu3496]

Hyyyy❤️

[@bestlearnings4265]

An easy way to creat understanding

[@unique_world666]

Gajab video hai sir

[@officialshanu3496]

Hyyyyy❤️

[@officialshanu3496]

Hyyy❤️

[@prashanttechnicalsupport]

Wow Work is very easy

[@foodandfast4603]

Superb sir

[@muhammadharoon8631]

Sir g made such types of video

[@officialshanu3496]

Hyyyyy

[@TheCreatorKaran.K]

sir aap ek VS code ka tutorial banao please 🙏🙏🙏🙏🙏

[@user-pl5fz6ph2d]

Thanks to Much sir....

[@darshitchavda8264]

NICE ONE

[@arunkumarsinghark3024]

शुक्रिया सर जी

[@sumankumar7215]

This is good way if it's work properly. I will try it

[@prahalladjena1634]

I am applying this types of pivot table formula.

[@Ravindra31sd]

Please sir insart tab excel video banaiye sir please aap ka video bhut achhe se samjh me aata hai sir

[@madeel6621]

LOVE YOU SIR

[@vinamrazema]

Thanks in my heart

[@manjit.sarania]

Very good teaching sir

[@kawmalmustafa1537]

Hi my dear sir thank

[@officialshanu3496]

Hyyy❤️

[@officialshanu3496]

Hyyyy❤️

[@AbdulHameed-vj1ng]

thanks iam looking for this trick thank you very much

[@mdjamsheda6828]

Thank you sir

[@SUMANDAS-js2kq]

Sir Excel ka please complete tutorial dijiyega one video pe?

[@officialshanu3496]

Hyyy❤️

[@AnjaliSharma-oy8hk]

Thankyou sir

[@manojjrkhiara240]

Excellent

[@khalidalisubhanallah2947]

Very knowledgeable video Sir

[@DeepakEduWorld]

After a long time… i m reading your comment 😊

[@vikashmourya8964]

Ap ek genius ho..... 🌈☄️

[@satyanksetu]

Dear Deepak, I have watched many of ur video on excel. Made my work easier and started enjoying working on excel. I need a solution from you Can we split files, as we print tiles with repeated column.

[@laxmansinghchouhan5866]

Nice 👍

[@MdRafid-iu3ni]

thank you so much

[@bijaytanty8434]

Good 👍

[@afrinsir7479]

very nice

[@PurchaseWB]

THANKS

[@mahendrachauhan2224]

Kya baat h

[@Ravindra31sd]

Excel me insart tabe ka video banaiye sir

[@princepaliapurty1453]

Sir beginner bala batch continuous kijiya na please

[@DeepakEduWorld]

New video jaldi aayega A To Z pe

[@officialshanu3496]

Hyyy❤️

[@bindu5449]

Thank you

[@kumarbiki2962]

Sir one excel sheet data se hum chuno hua logo ki data kese alag ek sheet per le sakta hain with out copy

[@naumanasgher5421]

Brilliant 👍🇵🇰🌺🌷🌹💐♥️🌸

[@bhauteshshah]

Hi Sir very good knowledge give by u sir! few querries... how can i add new salesman? once added new sheet will open as before ? if i wan to edit before entries will it update in new its Sheet ? If i missed out entries date wise will it added to sheet date wise? Thanks for reply.

[@vipraaggarwal268]

Great

[@officialshanu3496]

Hyyy❤️

[@vipraaggarwal268]

@@officialshanu3496 yes

[@SALEEM0409]

I love your work

[@officialshanu3496]

Hyyy

[@Ajay_Creations_]

Hello Sir Sir, Agar kisi workbook me 10 sheets h aur har sheet se mujhe kuchh particular values ko kisi another excel sheet me filter krna h to kaise krenge is pr ek video bna dijiye aur mujhe tag kr dijiye sir taki hm usko sikh sake ......please sir 🙏🙏🙏🙏🙏🙏🙏🙏

[@maqboolahmed8695]

Nice

[@zoebsultanali-rq7xo]

hi,sir after making this table and sheets, if i add new costumer or any column ,kaise unki sheet banegi

[@trilochanjena3836]

sir nice one. i want to know agar ek excel file me data entry user form banaya he vba dwara.. macro v he to us file ko banane ke baad.. us file ko dusro ko Cd/ pendrive me kese dena taki he wo apne offline computer me run kar sake sahi tarike se. plz guide.

[@arunkumarsinghark3024]

🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@satheeshgovindapai1824]

Sir I need merge of different sheets in master data as not combine or Power Query.i.e row wise

[@563abhinav]

Kaam ho gya sir aapka

[@satheeshgovindapai1824]

@@563abhinav no

[@danishsagheer8135]

Perfect Work

[@ramagiria6023]

Hello g

[@ramagiria6023]

I need formula for below Client Name Contact No. Sub Contract No Start Date End Date Remarks AABC A1 01-01-22 31-01-22 it should be showed "New" AABC A2 01-02-22 28-02-22 if renewed It should be showed. "Renewed" if not renewed should show "Not Renewed" AABCA3

[@nkgajjar]

Bro sahi he . Par alag alag sheet ko ek sheet me kese kare ? Please share idea

[@PradeepRawat]

Sir Thanks for your support to enhance my excel knowledge. I have a question for this topic if we put sr. No. First how can it will comes serial wise in separate sheet.

[@shaniwafa]

Hi Deepak, Most of videos are very much useful share and discuss among friends and group. But I have question that if a new salesman comes, would it be create a seperate sheet on refreshing

[@prakashbhagwat7127]

Same issue with me I want to use for customer but for new customer how will new sheet will generate

[@Rashidtech123]

Me hon depak... Ap ka dost... Lets begin this TOPIC....

[@hemrajataliya5641]

Hello, very impressive and knowledgeable video nd very useful too, I have two problems, hope you help me to get rid of my problems 1) i am using windows 7 ultimate, i had trouble in installing Microsoft office (even 97-2003),i had tried everything to make run office in my laptop(compaq 420),but failed to do so, As part of alternate way, i m using WPS, but many feature are not available for me, I am college going student and have to work in field of research work so please help me to get rid of this issue or suggest alternative of msoffice nd wps, i have to work mainly on excel, word nd PowerPoint, looking for early response Thanking you

[@pulakgoswami6697]

👌

[@Altaf_Alam]

❤️🔥💯

[@Thoran2016]

If i enter salesmen E details in master deta will it send to another sheet.

[@kavitadevi150]

kya sir jese home ab phir tnterst tab phir pagleyout tab fromule tab view en ki ek video bna do aap aacha krte ho sir please sir

[@parmeshwarpatel8556]

Tally ka full corce chahiye sir

[@dipkamal4647]

Hello sir, Shopping mall per Excel main kya Kya kya kam karna parta hain. Ek Complete Video Playlist Banayega. Please Sir.....🙏😊🤗🙏

[@khushboorathi3295]

Agar main after 6 months regular entry ek aur project sheet add Karni ho toh filter all mein saare project sheets aa rahi hai firse... koi aur Tarika hai jisme hum project add Kare toh filter se ek hi sheet add ho toh Naya list me add Kiya ho..is it possible?

[@girdharitex]

Dear sir Kya ye option excel 2007 me v available hai??

[@jaikishan1011]

Sir kio job advance excel ke lye batoo sir

[@acommonman155]

Kudus to you man

[@pankajinfoworld5310]

Sir I have 1 master data for Vehicle lubricants issue report and every week I add the data in master data through copy paste .. kindly provide simple process..

[@amarjeetsinghsoin81]

If i want to add a record with new name , new sheet will be added ?

[@Dhandhar.]

esa google sheet me bnta hoto guid krna plz

[@monseet-v9597]

Hello Deepak Sir, I have tried this trick it works well. But I'm facing an issue while updating the data from Mastersheet. When I update my data in the Mastersheet and go to "Name" sheets and refresh the table, the data does not update. Why does it happen? Please do let me know. Looking forward to your reply. Thank You!

[@Share1Share1]

How to remove (blank)? If one data it will show (blank).

[@prakashbhagwat7127]

Agar Naya number D Add- krenge to uska sheet kaise generate krenge

[@zakirhussain8931]

Before making pratise of your lecture our most time is waisted to make practise data or table there fore data should also be provided. Thanks

[@boatboat9783]

How can I down load samples of master date for making dash boards?

[@burhanbhat6643]

Please sir jee telegram par class onlyne do na.pura computer

[@officialshanu3496]

Hyyyy❤️

[@ravibisht8684]

Sir agar apsai training lai ni hu

[@yogawithprakash1269]

Thank sir how to make master sheet from different sheets that means per day only min,max, average in same workbook.

[@SunnyCool1110]

After that, if I have created a new record for Name E in a Master Sheet like Name A, B, C & D, then will create a dynamic excel sheet and data also? Please explain this scenario, how to do this dynamically? Thanks

[@aamirsaeed7919]

Thanks sir for making this video full of knowledge. I have a question related to this video. if master sheet have 100 salesmen, in this case how can we go to specific salesman sheet in single click than that of going to see sheets one by one. plz help in this problem. and plz must reply

[@kapilbishnoi9408]

Click on 3 dots try both left and right click there to go specific sheet it will show drop down box u can select from there or u can go direct through that filter where u selected all at the first place if u only wanna analyse the data

[@mdabdullah2429]

Sir this technica can use bangla data??

[@hamzaraza7429]

Sir mera Kam accounts ka Hy Mujhy kuch problem a rhi hy exel py Ap kuch help kr sakty hain ?