How To Create Automatic Excel Reports Using Macro | How To Use MACRO in Excel

Поділитися
Вставка
  • Опубліковано 5 вер 2024
  • How To Create Automatic Excel Reports Using Macro | How To Use MACRO in Excel
    in this video you will learn, how to create automatic excel reports using macro in excel. this excel video tutorial will show you how we can very easily create reports on dynamic [ unfixed ] data using advanced macro. in this video tutorial i told you some excel tips and tricks to record and use advanced macros. #ExcelTutorial #ExcelInHindi #MacroInExcel
    दोस्तों इस विडियो में मैंने बताया है की किस तरह आप Excel में Unfixed [ Dynamic ] Range के लिए macro record करके घंटों के हार्ड वर्क को मिनटों में सेकण्ड्स में कर सकते है | उम्मीद है आपको ये विडियो जरूर पसंद आएगा |
    Download Training File : drive.google.c...
    How To Use Macros In Excel • How to Use Macro in Ex...
    Macro videos:
    how to automatically transfer & Save data from one sheet to another using macro • How to Automatically T...
    How To Make ADVANCED FILTER Dynamic || Auto Updating || Filter To Another Sheet using macro • How To Make ADVANCED F...
    How To Automatically Transfer Current date Data To Another Sheet In Excel || Using Advanced Filter with macro • How To Automatically T...
    EXCEL में Boss को करना है Impress 😎 तो Macro का ये Magic सीखो • 😮 EXCEL में Boss को क...
    Excel के ये 2 intresting Macros आपको Excel में Smart बना देंगे - auto_open & auto_close • Macro in Excel || Exce...
    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...
    Google Forms Complete Tutorial : • Google Forms Complete ...
    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

КОМЕНТАРІ • 259

  • @DeepakEduWorld
    @DeepakEduWorld  5 років тому +18

    🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
    𝗣𝗹𝗲𝗮𝘀𝗲 𝗦𝘂𝗽𝗽𝗼𝗿𝘁 𝗠𝗲 𝗙𝗿𝗶𝗲𝗻𝗱𝘀 & 𝗦𝗵𝗼𝘄 𝗬𝗼𝘂𝗿 𝗟𝗼𝘃𝗲 𝗕𝘆 𝗟𝗶𝗸𝗲 𝗦𝗵𝗮𝗿𝗲 & 𝗖𝗼𝗺𝗺𝗲𝗻𝘁𝘀 😁
    🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
    𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)

  • @BalvirSingh-qs9kz
    @BalvirSingh-qs9kz 24 дні тому

    Sir, aapke sikhane ka tarika very nice. Thanks

  • @amareshnanda2099
    @amareshnanda2099 4 роки тому +5

    Dear Sir,
    I am having 17 yrs of experience in ms Excel but Everytime I found your lecture useful and the dynamic style of teaching.wish all success in future..thnx

  • @dipeshshah2925
    @dipeshshah2925 4 роки тому +1

    Superb

  • @pradeepnegi7523
    @pradeepnegi7523 2 роки тому +1

    Very nice sir

  • @sanjaydas-ez4kt
    @sanjaydas-ez4kt 3 роки тому +1

    Best

  • @atulsrivastava7230
    @atulsrivastava7230 6 місяців тому +1

    Thanks sir ji

  • @arthanarirajunagamanickam4966
    @arthanarirajunagamanickam4966 4 роки тому +1

    Useful vedio

  • @hanifqadri7636
    @hanifqadri7636 3 роки тому +1

    Very nice

  • @bhaveshparmar431
    @bhaveshparmar431 5 років тому +1

    Dynamic video

  • @pramodkumarmishra3779
    @pramodkumarmishra3779 5 років тому +1

    Bahut kam ki jankari hai thanks

  • @pranjalbhalani
    @pranjalbhalani 4 роки тому +1

    Very Usefull, Excel me aisa bhi ho sakta he aaj pata chala. Macro ke bare me suja jarur tha bus uska use kya he vo pata nahi tha. Video se bahot achhi information mili. Btw, all videos related to excell are very informative.
    Thx Deepak.

  • @AmarSingh-px9ro
    @AmarSingh-px9ro 4 роки тому +1

    Mast

  • @DeepakEduWorld
    @DeepakEduWorld  5 років тому

    Previous macro video.. Must watch it.. ua-cam.com/video/IMobswFP_Jg/v-deo.html

  • @TutanZone
    @TutanZone 5 років тому +1

    Awesome video

  • @AnilKumar-go7hj
    @AnilKumar-go7hj 4 роки тому +1

    Thanku sir very nice video 👌 video sir ji 100% working video

  • @abishekkumar7692
    @abishekkumar7692 Рік тому +1

    Love you sirr apse best koi nhi❤️👍👍

  • @pkshah2606
    @pkshah2606 5 років тому +1

    Nice video

  • @shanukumar87
    @shanukumar87 5 років тому +2

    Thank You Deepak Sir.. You had resolved my problem. Excellent Video.

  • @PPanchal762
    @PPanchal762 4 роки тому +1

    Thankyou sooo much sir it helps me alot because i have tansed from some days in my office a export data take time in doing one by one set i didnt use how to usr macro in the style that it sets automatically u save my daily 15mins which is too valuable to mr

  • @ashwanimishra9686
    @ashwanimishra9686 Рік тому +1

    Kaam kie baat baata

  • @rrentertainment2007
    @rrentertainment2007 3 роки тому

    very informative

  • @hasmukhparmar3524
    @hasmukhparmar3524 2 роки тому +1

    Your explanation style is better ...god bless you

  • @user-pl5fz6ph2d
    @user-pl5fz6ph2d 10 місяців тому +1

    Solid Solutions..... Thanks sir....

  • @deb1asis69
    @deb1asis69 4 роки тому +1

    Thanks for provide valuable videos

  • @kantaprasad232
    @kantaprasad232 5 років тому +1

    supperrrrrrrrrrr

  • @paruljoshi3770
    @paruljoshi3770 5 років тому +3

    Super 👌👌👌😃😃😃

  • @DasBabu1
    @DasBabu1 5 років тому +1

    Ami khub help payachi tnq da💜💜

  • @agribhagatbharatiye5376
    @agribhagatbharatiye5376 4 роки тому +1

    Very good information

  • @hiteshchourey9730
    @hiteshchourey9730 Рік тому +1

    Sirji, vlookup on multiple sheets ka video banaye 100 row 8 columns tak data fecth kare. One time par.

  • @ksvikas5
    @ksvikas5 3 роки тому

    u r master of excel 🙏🏻🙏🏻🙏🏻

  • @vijaybhairavjibhaiode2357
    @vijaybhairavjibhaiode2357 4 роки тому

    Very very nice

  • @pervaizbughio2993
    @pervaizbughio2993 2 роки тому +2

    Deepak! you are marvellous, good work please keep it up, god bless you.

  • @v.lsuryawanshi3780
    @v.lsuryawanshi3780 2 роки тому +1

    Nice bhaiya ji

  • @mahaboobhossain5076
    @mahaboobhossain5076 4 роки тому +1

    Your videos are outstanding

  • @srishtisharma3965
    @srishtisharma3965 3 роки тому +1

    Superb video sir

  • @neerajdhawan3565
    @neerajdhawan3565 4 роки тому

    I have become champ in excel only by your help

  • @nehaparveen1290
    @nehaparveen1290 4 роки тому +1

    Fantastic thnx alot sir ji

  • @santhoshps
    @santhoshps 5 років тому +1

    Thanks

  • @arthanarirajunagamanickam4966
    @arthanarirajunagamanickam4966 4 роки тому +1

    Very Useful

  • @pintu4420
    @pintu4420 5 років тому +1

    Very useful video Brother

  • @MdIlyasShaikh
    @MdIlyasShaikh 5 років тому +1

    Bahot lhoob sir

  • @vasalji
    @vasalji 4 роки тому +2

    Namaskar. I think this can fulfill my requirement of continued updation from one Excel file to another file. I will try it . Thank you very much.

  • @kiransati3508
    @kiransati3508 4 роки тому

    Thanks sir....

  • @shabarilucky5
    @shabarilucky5 5 років тому +1

    Thanks again Deepak jee.🤝

  • @prakashkumar-tf9nt
    @prakashkumar-tf9nt 5 років тому +6

    Please sir Excel MIS par bhi full video banaye...🙏🙏🙏

  • @sundarsinghsonar3381
    @sundarsinghsonar3381 4 роки тому

    You are genius sir.. Thanks for such video.

  • @nurulteck9107
    @nurulteck9107 4 роки тому

    I liked it very much thanks for sharing this video

  • @DhrumilSakhavala
    @DhrumilSakhavala 4 роки тому +1

    Sir bank vale account number likhakar money add ker ke our balance auto change kaise hota hai ?
    Please make video on this topic .

  • @arjasarkar13
    @arjasarkar13 4 роки тому +1

    Just too good. God Bless You!

  • @prabhakarpawar573
    @prabhakarpawar573 4 роки тому

    Very usefull video Deepak Sir

  • @MrPZAHOOR
    @MrPZAHOOR 5 років тому +1

    thank you so much Deepak Sir. I fall short of words to Parise you sir. Your attitude of teaching admirable sir. I am so impressed by you sir. Thank you very much

  • @nishachauhan9103
    @nishachauhan9103 3 роки тому +1

    👌👌👌👌👌👌👌👌👌👌👌

  • @ShivamYadav-fo7wc
    @ShivamYadav-fo7wc 2 роки тому

    Nice sir

  • @sidsawant
    @sidsawant 5 років тому +1

    Your videos always different & most useful.....

  • @myhelpdesk6414
    @myhelpdesk6414 5 років тому +1

    Sir AAP gjb ho awesome thanks for share...

  • @sanchiraut786
    @sanchiraut786 4 роки тому +1

    Superb... Sir. 👌👌

  • @keshavkashyap8634
    @keshavkashyap8634 4 роки тому

    I like your every video Thanks for lovely support sir
    Thanks for your support

  • @Success_Mantra82
    @Success_Mantra82 5 років тому +1

    Nice learning 👌 *Deepak ji*

  • @sohrabkhan1969
    @sohrabkhan1969 4 роки тому

    Thanks sir for your best and useful tutorials

  • @akileshsharma2523
    @akileshsharma2523 4 роки тому +3

    Hi Deepak, Thank you for this wonderful class.
    Please do a one more video on how to buy a MS Office pro, at low cost.

  • @anilkumarchaurasiya7060
    @anilkumarchaurasiya7060 8 місяців тому

    Very nice explanation sir 🙏 thanks

  • @saumyaranjan1435
    @saumyaranjan1435 4 роки тому

    Deepak sir you are a genius 🙏🙏🙏🙏

  • @ramchandramahamuni5932
    @ramchandramahamuni5932 4 роки тому

    Very good knowledge and also teaching...the way you explained....very nice

  • @wahidrashid4865
    @wahidrashid4865 5 років тому +1

    sir you are so genius

  • @ManishJain-fr8oy
    @ManishJain-fr8oy 4 роки тому +1

    Thanks Sir

  • @twinklejaiswal7486
    @twinklejaiswal7486 5 років тому +1

    Sir super videos

  • @mahaboobhossain5076
    @mahaboobhossain5076 4 роки тому +1

    Deepak brother I want a video of choose functions

  • @ShoebShaikh-jk7jk
    @ShoebShaikh-jk7jk 3 роки тому +1

    Good Job!

  • @laxmitamboli1729
    @laxmitamboli1729 4 роки тому

    Thank u it will help me in office work

  • @goyalmukeshkumar
    @goyalmukeshkumar 4 роки тому

    Super

  • @epariajitkumar9871
    @epariajitkumar9871 3 роки тому

    Very nicely explained dear. It's so useful and excellent...

  • @sajadshama
    @sajadshama 2 роки тому

    😇👍👍👍very useful video Sir ☺️ thanks

  • @twinklejaiswal7486
    @twinklejaiswal7486 5 років тому +1

    Love you sir

  • @vinay103
    @vinay103 5 років тому +1

    Nice trik

  • @mshahzadkhan4454
    @mshahzadkhan4454 2 роки тому

    Love from Pakistan

  • @jayantkulkarni195
    @jayantkulkarni195 3 роки тому

    Thx.

  • @AnilKumar-gj5xj
    @AnilKumar-gj5xj 4 роки тому

    सर नमस्कार मैं आप की लगभग सारी वीडियो देखता हूं और मुझे बहुत अच्छी लगती
    है
    सर क्या माइक्रो का यूज हम आपकी जो मार्कशीट वाली वीडियो है उसमें यूज कर सकते है
    कृपया रिप्लाई जरूर करें आपका बहुत-बहुत धन्यवाद🙏

  • @AnuragSingh-vy7nn
    @AnuragSingh-vy7nn 5 років тому +1

    Really,, very helpful

  • @twinklejaiswal9895
    @twinklejaiswal9895 5 років тому +1

    Sir love you 💘💖💕💖💘💕💖💖💕💖💖💕

  • @bhaveshparmar431
    @bhaveshparmar431 4 роки тому

    Big work become micro

  • @lalitsingh5263
    @lalitsingh5263 Рік тому

    Happy new year deepak sir

  • @saeedahmed-ks6ob
    @saeedahmed-ks6ob Рік тому +1

    if i put excel data in multiple rows, how will it reflect on a separate word sheets and specific place where i need it

  • @darshansatvara6449
    @darshansatvara6449 2 роки тому

    Thank you so much sir
    Muje ek question he ki koi esa video banyiye micro me ki one entry kariye ek sheet k andar or dusri sheet k andar bhi entry kare to to uska Automatically last master sheet me Vo entry aa jaye or uski second master me bhi copy ho jaye line wise
    1 sheet me me kuch change karu to jo master me first sheet ka data ho vahahi add ho jaye or 2 sheet ka data me change karu to vo bhi master sheet me reflect ho jaye wo bhi line wise adjust ho jaye

  • @mewaramtoliya53
    @mewaramtoliya53 4 роки тому

    Main dekh raha hau, main soon bhi raha hau, kya main samajh raha hau, Thase condation continue your all vedio

  • @ramchandramahamuni5932
    @ramchandramahamuni5932 4 роки тому

    Most of civil engineers build estimates in excel.... This is most useful for that....

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki Рік тому +1

    Sir vlookup or sumif sumifs countif countifs ka macro record ki video bnao plz plz🙏 plz🙏 plz🙏 plz🙏

  • @Technical3Idiots
    @Technical3Idiots 5 років тому +1

    Wonderfull... Very informative...

  • @hiteshchourey9730
    @hiteshchourey9730 9 місяців тому

    Excel mai macro with subtotal ka use kaise karege. Video banaye please

  • @shahanimhj1902
    @shahanimhj1902 3 роки тому

    Sir Inventory management system per video banayn, please

  • @SibenduJena
    @SibenduJena 4 роки тому +2

    Please upload a video in macro that can connect different sheets and automatically change dates

  • @ashishkapil259
    @ashishkapil259 Рік тому

    Deepak, kindly make a video cells data shouldn't be copy....

  • @ranjeetsinghsingh680
    @ranjeetsinghsingh680 2 роки тому +1

    Record macro wali window me shortcut key me cltr+ shift+provided key ka option aata h
    To kya ctrl +provided key se macro run hoga

  • @amitmahawaly2187
    @amitmahawaly2187 5 років тому +2

    Sir ji java script ki latest video bnaker upload kr do..... please sir ji jaldi krna

  • @perwezalam5444
    @perwezalam5444 5 років тому +1

    Sir, macro ko ek video main basic to advance explain kijiye aur video banaye plzzz

  • @idspnashik9083
    @idspnashik9083 3 роки тому

    sir plz make video on how to create micros with pivot table

  • @ganeshkadu6042
    @ganeshkadu6042 7 місяців тому

    👍👍👍

  • @m.a.kareem1343
    @m.a.kareem1343 4 роки тому +1

    Sir Excel mein change aur fix paragraph ke liye macro ka video banayiye sir,

  • @ayeshaKhan-dd4dg
    @ayeshaKhan-dd4dg 5 років тому +1

    Thanx

  • @sherazrathoor8552
    @sherazrathoor8552 5 років тому +2

    Sir or courpt data kesa repair kra word excel img file etc es p bhe video bna da