Тёмный

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

Deepak EduWorld
Подписаться 1,2 млн
Просмотров 288 тыс.
50% 1

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

Опубликовано:

 

29 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 217   
@baharali7429
@baharali7429 2 года назад
Excellent work thanks for your teaching very. Thanks
@officialshanu3496
@officialshanu3496 2 года назад
Hyyy❤️
@shaileshgaud8589
@shaileshgaud8589 2 года назад
Dil se thanks 👍 Video Creator + People like me ! Who come to learn something new on RU-vid.😇😇😇🙏
@Hey-come-and-learn
@Hey-come-and-learn 6 дней назад
Mere pas excel 07 hai usme nhi a rha pivot table analyse ka option
@prakashbhagwat7127
@prakashbhagwat7127 7 месяцев назад
Agar Naya number D Add- krenge to uska sheet kaise generate krenge
@AnwarSadat-f9t
@AnwarSadat-f9t Месяц назад
Deepak Greetings thank you for teaching very easy way How can i transfer DATA's from one sheet to multiple sheet based on serial number (from serial 1 to 300 one sheet and 301 to 600 another sheet like that0
@Ajay_Creations_
@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 🙏🙏🙏🙏🙏🙏🙏🙏
@zoebsultanali-rq7xo
@zoebsultanali-rq7xo 7 месяцев назад
hi,sir after making this table and sheets, if i add new costumer or any column ,kaise unki sheet banegi
@khushboorathi3295
@khushboorathi3295 11 месяцев назад
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?
@teraname4177
@teraname4177 2 года назад
दुबारा नेक्स्ट शीट के लिए जोड़ना हो किसी दूसरे को तब क्या करेंगे
@satheeshgovindapai1824
@satheeshgovindapai1824 2 года назад
Sir I need merge of different sheets in master data as not combine or Power Query.i.e row wise
@563abhinav
@563abhinav 2 года назад
Kaam ho gya sir aapka
@satheeshgovindapai1824
@satheeshgovindapai1824 2 года назад
@@563abhinav no
@amarjeetsinghsoin81
@amarjeetsinghsoin81 Год назад
If i want to add a record with new name , new sheet will be added ?
@Thoran2016
@Thoran2016 Год назад
If i enter salesmen E details in master deta will it send to another sheet.
@kumarbiki2962
@kumarbiki2962 Год назад
Sir one excel sheet data se hum chuno hua logo ki data kese alag ek sheet per le sakta hain with out copy
@Share1Share1
@Share1Share1 Год назад
How to remove (blank)? If one data it will show (blank).
@princepaliapurty1453
@princepaliapurty1453 2 года назад
Sir beginner bala batch continuous kijiya na please
@DeepakEduWorld
@DeepakEduWorld 2 года назад
New video jaldi aayega A To Z pe
@officialshanu3496
@officialshanu3496 2 года назад
Hyyy❤️
@kishorpheonix
@kishorpheonix Год назад
Kya apka e mail id mil skta hai...? For quarry
@Dhandhar.
@Dhandhar. 2 года назад
esa google sheet me bnta hoto guid krna plz
@ranasajidali9604
@ranasajidali9604 2 года назад
Thank for your unique teaching style. (Lahore)
@SUMANDAS-js2kq
@SUMANDAS-js2kq 2 года назад
Sir Excel ka please complete tutorial dijiyega one video pe?
@officialshanu3496
@officialshanu3496 2 года назад
Hyyy❤️
@TheCreatorKaran.K
@TheCreatorKaran.K 2 года назад
sir aap ek VS code ka tutorial banao please 🙏🙏🙏🙏🙏
@burhanbhat6643
@burhanbhat6643 2 года назад
Please sir jee telegram par class onlyne do na.pura computer
@officialshanu3496
@officialshanu3496 2 года назад
Hyyyy❤️
@vikramghuge5628
@vikramghuge5628 Год назад
Sir Filter me balnk data me 0 aata hai
@a.pcompetitionboss1341
@a.pcompetitionboss1341 2 года назад
Excel ke pdf mil shikari h kat
@jigneshdadhaniya2548
@jigneshdadhaniya2548 2 года назад
How can I get download sheet
@ravibisht8684
@ravibisht8684 2 года назад
Sir agar apsai training lai ni hu
@deepanshi3838
@deepanshi3838 2 года назад
How to add new employee name
@TheCreatorKaran.K
@TheCreatorKaran.K 2 года назад
sir aap ek VS code ka tutorial banao please 🙏🙏🙏🙏🙏
@zakirhussain8931
@zakirhussain8931 11 месяцев назад
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
@parmeshwarpatel8556
@parmeshwarpatel8556 2 года назад
Tally ka full corce chahiye sir
@swatikiranrath2924
@swatikiranrath2924 2 года назад
Me month wise attendance sheet bana rahi huin.but me chahti huin ki master sheet me jis mahine ki data entry karun wo automatically usi month ki sheet me entry ho jayen wo v without copy me.example me January ka data entry Kiya master sheet me aur me chahti huin ki without copy wo January ke sheet me automatically entry and save ho jaye.Plz help me
@pankajinfoworld5310
@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..
@bestlearnings4265
@bestlearnings4265 Год назад
An easy way to creat understanding
@nidhikhandelwal277
@nidhikhandelwal277 2 года назад
Sir y function WPS m kaam kyu ni kar raha usme pivot report analysis tool show ni ho raha...sir please help
@muhammadharoon8631
@muhammadharoon8631 2 года назад
Sir g made such types of video
@officialshanu3496
@officialshanu3496 2 года назад
Hyyyyy
@arshadshafique4460
@arshadshafique4460 Год назад
Hello I'm facing a issue where I added my headers as months in the format mmm-yy but pivot table converted my data to numbers and when I changed it back the sheets made had no name.
@kavitadevi150
@kavitadevi150 2 года назад
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
@sujata-jn2sb
@sujata-jn2sb 2 года назад
Sir koi part time job h student ke liye jaha wo 2 ya 4 hour. Kaam karke apna pocket kharch nikal sake aur padhai bhi krta rhe
@nishashakya4913
@nishashakya4913 2 года назад
Sir Excel ki ek worksheet m kitni sheet hoti h ...plss confirm me
@adityaverma2720
@adityaverma2720 2 года назад
1 workbook me 255 sheets add kar sakte hai
@Gwalaji
@Gwalaji Год назад
गलत बता रहे है आप सर जी
@nishashakya4913
@nishashakya4913 Год назад
Sir new version m bhi 255 hi
@solemankhan5258
@solemankhan5258 Год назад
255
@arunkumarsinghark3024
@arunkumarsinghark3024 2 года назад
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@ramkishorjatt3066
@ramkishorjatt3066 2 года назад
sir ek dikita h
@officialshanu3496
@officialshanu3496 2 года назад
Hyyyyy
@RamPrakash-ic1sn
@RamPrakash-ic1sn 6 месяцев назад
यदि हम नया salesman add करते हैं तो क्या उस की अलग शीट कैसे बनेगी?
@boatboat9783
@boatboat9783 Год назад
How can I down load samples of master date for making dash boards?
@yogawithprakash1269
@yogawithprakash1269 Год назад
Thank sir how to make master sheet from different sheets that means per day only min,max, average in same workbook.
@Siddhu-v3e
@Siddhu-v3e 2 года назад
Dear sir Kya ye option excel 2007 me v available hai??
@harunpradhan1379
@harunpradhan1379 2 года назад
Hi sir, mujhe kuch replace karna tha lekin nehi ho pa raha hai mujhse, please mujhe help chahiye apka, name ke against me kuch 1,2,3.....14 number hai. Usme se 1 ke replace 111.33 aor 2 ke replace 222.66 kuch iss tarha hoga lekin kuch problem face kar raha hu, please mere liye ek video bana dijiye
@manjit.sarania
@manjit.sarania 2 года назад
Sir amazing..I'm learning a lot from u..🙏🙏🙏
@zafarkhan5741
@zafarkhan5741 Год назад
Sir A,B,C,ke bad D,E,F ya aur name jodte hain master sheet me to unki alag se sheet nahi show ho rahi plz help me to solve this problem
@muhammadatharkhurshid7077
@muhammadatharkhurshid7077 10 дней назад
Excellent
@manubhaidarji1145
@manubhaidarji1145 Год назад
sheet 1 me 60 name Hai usko sheet 2 me le jana Hai aur wo sheet me name wali columns merge ho to kya formula use kare??? Drag karne se nahi aata Sir please solve this problem!!!!!
@bhauteshshah
@bhauteshshah 2 года назад
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.
@samirpadhy4368
@samirpadhy4368 4 месяца назад
sir if new customer name come then how we will update with new file from him can you explain
@mahendrachauhan2224
@mahendrachauhan2224 Год назад
Kya baat h
@ramkishorjatt3066
@ramkishorjatt3066 2 года назад
hii
@hamzaraza7429
@hamzaraza7429 2 года назад
Sir mera Kam accounts ka Hy Mujhy kuch problem a rhi hy exel py Ap kuch help kr sakty hain ?
@zubairhaiderlodhi5207
@zubairhaiderlodhi5207 8 месяцев назад
Sheet A Sheet B Sheet C Sheet D Will this new name sheet insert it. self ? Sheet name ???
@uditprajapatiofficialreal3972
Super 😊😊 master class 🤗 dil se dhanyawad 🙏🚩 Jay shree Ram
@sujeetresearch1022
@sujeetresearch1022 2 года назад
Sir mera ak question h aapse cell me kahi pr text likha h uska pahla letter ko capital me ak baar me kaise kare plz
@kawmalmustafa1537
@kawmalmustafa1537 2 года назад
Hi my dear sir thank
@officialshanu3496
@officialshanu3496 2 года назад
Hyyy❤️
@officialshanu3496
@officialshanu3496 2 года назад
Hyyyy❤️
@anapplemango9464
@anapplemango9464 2 года назад
Hello sir, it's too good, I really appreciate you, you have to right, I say again & again thanks a lot.
@muhammadharoon8631
@muhammadharoon8631 2 года назад
I love with excel
@officialshanu3496
@officialshanu3496 2 года назад
Hyyyy❤️
@ManojTiwari-fq7gy
@ManojTiwari-fq7gy Год назад
Master sheet bhi month wise 12 ho aur data har month sheet se salesman Alag Alag salesmen ko transfer ho Jaye. jaise account me Hota Hai. Aisa karna hai to kaise Karege
@nkgajjar
@nkgajjar 2 года назад
Bro sahi he . Par alag alag sheet ko ek sheet me kese kare ? Please share idea
@himalayanpowerpartnerltd.7274
@himalayanpowerpartnerltd.7274 2 года назад
Is there any method to enter data using a single data entry form to enter data in different sheets? I have to enter 24 hours different data for each day of the month using same single entry form. Each sheet has one day data.
@mohdabdullah2088
@mohdabdullah2088 Год назад
Suppose humare paas 3000 data hai master sheet me, lekin humko ab isko sirf 30 data hi lena hai separate sheet me for 100 sheets To ye kaese hoga?
@nakulanand2725
@nakulanand2725 3 месяца назад
Very useful video sir, agar hume multiple sheets me se ek master sheet banani h toh kaise karenge pls bataye?
@naumanasgher5421
@naumanasgher5421 Год назад
Brilliant 👍🇵🇰🌺🌷🌹💐♥️🌸
@samirpadhy4368
@samirpadhy4368 4 месяца назад
suppose sale man e come later than how can we update with new file for him
@sumankumar7215
@sumankumar7215 2 года назад
This is good way if it's work properly. I will try it
@ujwalasalunkhe4398
@ujwalasalunkhe4398 Год назад
Sir excl me tally jese har YK party ka name our uska email detail type karke ..... Y me kesa ledger me m Dale to m party name ate ye esa ATA he kya
@Ravindra31sd
@Ravindra31sd 2 года назад
Excel me insart tabe ka video banaiye sir
@kmkthoughts8266
@kmkthoughts8266 2 года назад
Please in English.. Then only i can understand
@Parmeshwar-p6b
@Parmeshwar-p6b 11 месяцев назад
very good excel concept , Thank you so much for video
@barasaradivyesh2422
@barasaradivyesh2422 Год назад
Hello sir, Muje jo sheet create hue he usko sperate file me transfer karna he to wo kese hoga?
@Altaf_Alam
@Altaf_Alam 2 года назад
❤️🔥💯
@vipraaggarwal268
@vipraaggarwal268 2 года назад
Great
@officialshanu3496
@officialshanu3496 2 года назад
Hyyy❤️
@vipraaggarwal268
@vipraaggarwal268 2 года назад
@@officialshanu3496 yes
@koushikmandal8311
@koushikmandal8311 2 месяца назад
😊😊❤🎉
@rimamridha7066
@rimamridha7066 Год назад
i want to do same thinng but in different wookbook
@ahmovies52
@ahmovies52 Месяц назад
Othar name add kri to alag sheet option nahi banega sir 😢😢😢
@video_banani_nahi_aati
@video_banani_nahi_aati 2 года назад
Jab table m hi convert kar diya data ko to faltu m last column add kiya h.
@Siddhu-v3e
@Siddhu-v3e 2 года назад
Mujhe pivot analyse ka option nahi mil rha 2007 me.
@Emax_Education_Nizampur
@Emax_Education_Nizampur 21 день назад
Usme option hota h
@sureshkumarpatwa8946
@sureshkumarpatwa8946 Год назад
We can also get each sheet just by double clicking the names in pivot table. New sheet will created by double click
@harinderhanu
@harinderhanu Год назад
Par wo sahi tareeka nahin hai bhs**
@navneetsharma2532
@navneetsharma2532 3 месяца назад
Sir, filter sheet par ID continue nahi hai
@irfanchauhan313
@irfanchauhan313 2 года назад
Thank You very much for your constant support for the people. You are really helping us a lot. You have increased our knowledge. 🙏
@blackmerchantkale
@blackmerchantkale 6 дней назад
Thank you so much
@FaizShan-bo2id
@FaizShan-bo2id Год назад
Sir mujhe 5 piclist ko ek sath Qty krna hai oo kaise ho
@asifshekh9311
@asifshekh9311 8 месяцев назад
Sheets alag alag ban ne k baad unpe se filter kese hataye?
@mdabdullah2429
@mdabdullah2429 Год назад
Sir this technica can use bangla data??
@leela911
@leela911 Год назад
Sir google sheet मे कैसे करेंगे ये
@manojkulkarni6749
@manojkulkarni6749 2 года назад
Really Knowledgeable video Thanks
@jaikishan1011
@jaikishan1011 2 года назад
Sir kio job advance excel ke lye batoo sir
@bhatowais5729
@bhatowais5729 2 года назад
Sir serail no thek kaise hoga serially nahi rehta hai na data Sheets pe sir
@raajlakra1558
@raajlakra1558 10 месяцев назад
Sir Master Sheet me new name entry karne se new sheet q nai bata hai
@krishanjha8930
@krishanjha8930 2 года назад
Add new sales man how to create new table
@kavitadevi150
@kavitadevi150 2 года назад
sir mere comment nhi dekhte sir
@09shirish
@09shirish 2 года назад
Nice information, thanks Sirji !
@mohammedasifshaikh622
@mohammedasifshaikh622 2 года назад
There is no use of making Filter column as without it will also work.
@DeepakEduWorld
@DeepakEduWorld 2 года назад
You can try 👍
@excelkarnesehoga-kali9957
@excelkarnesehoga-kali9957 Год назад
Sir I appreciate your unique trick
@dipkamal4647
@dipkamal4647 2 года назад
Hello sir, Shopping mall per Excel main kya Kya kya kam karna parta hain. Ek Complete Video Playlist Banayega. Please Sir.....🙏😊🤗🙏
@bishnukumar1006
@bishnukumar1006 2 года назад
How to add Automatic all the sheets
@ramkishorjatt3066
@ramkishorjatt3066 2 года назад
h8
@officialshanu3496
@officialshanu3496 2 года назад
Hyyyyy
Далее
ХОККЕЙНАЯ КЛЮШКА ИЗ БУДУЩЕГО?
00:29
🔥Don't Use Formula | Use Excel Magic Trick Ctrl+E
9:19
How to Move Data Automatically Between Excel Files
11:37