Transfer Data From One Sheet to Multiple Sheets Automatically in Excel (Hindi)

Transfer Data From One Sheet to Multiple Sheets Automatically in Excel (Hindi)
In this easy and simple video tutorial, you will know how to send data from one sheet to many other sheets according to their criteria.
By the way we have made many videos on Macro but in this video you will learn another amazing use of Excel Macro.
-----------------------------------------------------------------------
Download Our Excel Workbook: drive.google.com/file/d/19ezl...
-----------------------------------------------------------------------
Relative Videos:
1.Drop Down List In Excel Hindi
• How To Create Auto Upd...
2. Dependent Drop Down List in Excel
• Dependent Drop Down Li...
____________________________________________
Other Most Popular Videos:
1. Stock Management in Excel (Hindi)
• Stock Management in Ex...
2. How to Create Day Book Report in Excel in Hindi Step by Step
• How to Create Day Book...
3.How to Create Day Book Report in Excel in Hindi Step by Step Part - 2
• How to Create Day Book...
4. How to Create GST Invoice in Excel in Hindi | Tax Invoice Template
• How to create GST Invo...
5. Credit Controlling Sheet in Excel in Hindi
• Credit Controlling She...
6. How to Calculate ROI in Excel (Hindi)
• How to Calculate ROI i...
7. How to Make Letterhead Design in Microsoft Word
• How to Make Letterhead...
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi
#transferdata
#powerxbyjitendra
#excel
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.

Пікірлер: 52

  • @ariyaantanjir7404
    @ariyaantanjir74042 жыл бұрын

    Thanks a lot Sir

  • @SHIVAMKUMAR-ek4oy
    @SHIVAMKUMAR-ek4oy2 жыл бұрын

    VERY nice

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

    It is great of you. Great that I am learning from you. However, will be possible to make in Google Sheet.

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

    I am your big fan. I always watch your videos, and I find your videos very useful. Sir, I am making a request to you, if you could make some videos on google sheets and apps sheets, it would be very helpful. I look forward to your videos. Hope you will accept my request and make some videos on this topic soon. Thank you very much sir.

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

    Nice sir

  • @manjit.sarania
    @manjit.sarania Жыл бұрын

    I'm learning from u sir. 🙏🙏

  • @PowerExbyJitendra

    @PowerExbyJitendra

    Жыл бұрын

    I am glad 😊 to hear it

  • @avneshsharma1507
    @avneshsharma15073 жыл бұрын

    Too good sir 👍👍👍👍

  • @PowerExbyJitendra

    @PowerExbyJitendra

    3 жыл бұрын

    Thanks Avnesh

  • @motaharbg7218
    @motaharbg72183 жыл бұрын

    Dear Sir, I am a Bangladeshi and am grateful to you for this learning video. I saved your link and will see other videos. Thank you

  • @PowerExbyJitendra

    @PowerExbyJitendra

    3 жыл бұрын

    It is so kind of you

  • @deepakdalal8731
    @deepakdalal87313 жыл бұрын

    Nyc.., sir jii

  • @PowerExbyJitendra

    @PowerExbyJitendra

    3 жыл бұрын

    Thanks Deepak ji

  • @ravinderrathee3116
    @ravinderrathee31163 жыл бұрын

    Sir is it possible to hide formula to avoid any issue in future

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

    Does it work with macro save button? Where macro saves data into spreadsheets

  • @biswajitkaran89
    @biswajitkaran892 жыл бұрын

    Excellent Sir. But I do not want to make separate sheet for every customer . I want to see the customers details in same sheet through Dropdown List. How can it possible ?

  • @sohelarman8056
    @sohelarman80563 жыл бұрын

    Sir, daily collection debit credit se hoga

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

    Sir very informative video, but I have more than 100 customers, is there a dynamic way to create macro for such a large number of customers. Thanks

  • @rajinder.s.bisht98
    @rajinder.s.bisht983 жыл бұрын

    Sir I have Seen Your Stock Maintenance Video Part 1 ,2,3 and part 4

  • @PowerExbyJitendra

    @PowerExbyJitendra

    3 жыл бұрын

    So kind of you

  • @jayanthamadasekera8248
    @jayanthamadasekera82485 ай бұрын

    When excel macro is run the formula also disappearing, how to avoid this?

  • @shivkantupadhyay9747
    @shivkantupadhyay97473 жыл бұрын

    Sir agar aur data update karna ho toh ya add karna ho tab

  • @RAJANADEEMish
    @RAJANADEEMish2 жыл бұрын

    I have work many companys if i send you full file can u creat data base ?

  • @RAJANADEEMish
    @RAJANADEEMish2 жыл бұрын

    Hi sir

  • @consulgeneralkunmingchina1010
    @consulgeneralkunmingchina10102 жыл бұрын

    can you send me the file my one is not working showing message need to add some codding.

  • @saurabh17sharma68
    @saurabh17sharma683 жыл бұрын

    Nice video sir macro laga hai kya isme

  • @PowerExbyJitendra

    @PowerExbyJitendra

    3 жыл бұрын

    Ha ji

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

    How much can I use micro in excel sheet?

  • @rajinder.s.bisht98
    @rajinder.s.bisht983 жыл бұрын

    Sir nice Sir Sir Pivot Table Pivot Chat Mis Par bhi Video Banaye Sir Please I hope We will see Above mention Video Request Thank You Sir

  • @PowerExbyJitendra

    @PowerExbyJitendra

    3 жыл бұрын

    Ji sir pivot chart par video zaroor ayega

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

    Sir, Can I reverse this formula, I mean, I want to transfer data automatically from different sheet to one sheet...is it possible

  • @kaitiprema
    @kaitiprema3 жыл бұрын

    Can it will be calculation

  • @shahidimranrandhawa8599
    @shahidimranrandhawa85993 жыл бұрын

    FROM SHEET 1 .WHEN DOING DATA VOLIDION IS NOT WORKING .WHY....

  • @sohelarman8056
    @sohelarman80563 жыл бұрын

    Daily Incoming and outgoing automatically posting to ledger. Please ak video baniy.

  • @PowerExbyJitendra

    @PowerExbyJitendra

    3 жыл бұрын

    Ok Sohel ji I will try

  • @vedventure2794

    @vedventure2794

    3 жыл бұрын

    I also need

  • @manmohanyadavg260
    @manmohanyadavg2603 жыл бұрын

    Sir, यदि मेरे पास बहुत से customer हों तो क्या मैं advance filter और मैक्रो की हेल्प से सभी customer का ऑटोमैटिक अलग अलग शीट पर customer wise data creat कैसे कर सकता हूं । ये बताइए कृपया। जिस प्रकार pivot table से करते हैं।

  • @PowerExbyJitendra

    @PowerExbyJitendra

    3 жыл бұрын

    हा जी Manmohan

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

    Formula write

  • @Ziever_editz
    @Ziever_editz2 жыл бұрын

    Hi sir my customer criteria start with digit number, when I go to macro to start recording is shows that criteria must be with words not digit number. Please help

  • @Ziever_editz

    @Ziever_editz

    2 жыл бұрын

    My customer criteria is 35 UTS, 2915 PTF, 175 ALT like this then how to record macro with these names, it's urgent please clarify.

  • @prempman
    @prempman3 жыл бұрын

    Sir mujhe 1 topic pe video chahiye. Mere sare format ready he purchase order ke.. To me jo bhi purchase order me type karu uski entry mujeh manually different sheet me karni padti he.... To aesa kuch jo me purchase order ki sheet me type karu vo data automatically dusri sheet me chala jaye single click se

  • @PowerExbyJitendra

    @PowerExbyJitendra

    3 жыл бұрын

    Is video mai yahi bataya gaya hai

  • @paradisedreams3639
    @paradisedreams36393 жыл бұрын

    Hi sir... I have one doubts .. Same method I created excel sheet Once save and closed sheet again open the this excel sheet does not work macro

  • @PowerExbyJitendra

    @PowerExbyJitendra

    3 жыл бұрын

    Dear Arun, You have to save this file as Excel Macro Enabled workbook. Please watch the below video at the end it is taught in detail. kzread.info/dash/bejne/qZl216WTh9XJhLA.html

  • @Levi-vb1nq

    @Levi-vb1nq

    2 жыл бұрын

    i already save file enable marco but still not working when i open file again. please help me sir

  • @rajeshsinghjadham9899
    @rajeshsinghjadham98993 жыл бұрын

    Thanks sirji Lekin har bar table lena jarrory hai kya

  • @PowerExbyJitendra

    @PowerExbyJitendra

    3 жыл бұрын

    Bahut zaroori hai nahi to ranges automatically update nahi hongi

  • @rajeshsinghjadham9899

    @rajeshsinghjadham9899

    3 жыл бұрын

    @@PowerExbyJitendra Ok thanks sirji

  • @mdmotivationline7789
    @mdmotivationline77892 жыл бұрын

    Yeh to hamnai kar liya 50 se 100 sheet mai kaisai ek sath karai 3 sheet mai sab ka alag macro record kiya

  • @ArifKhan-nf5jm
    @ArifKhan-nf5jm5 ай бұрын

    Sir Muje agar uniq numbers se customer find karna pade to kiya karna honga.

Келесі