How to Automatically Transfer & Save Data From One Sheet to Another in Excel || HINDI

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ต.ค. 2024

ความคิดเห็น • 1.6K

  • @DeepakEduWorld
    @DeepakEduWorld  5 ปีที่แล้ว +20

    🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
    *Show Me ♥ By Like Share & Comment*
    🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
    *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

    • @srpgroup-8gondal671
      @srpgroup-8gondal671 5 ปีที่แล้ว

      What to do to transfer all rows other than zero values into another sheet

    • @VISHNU-cr6nb
      @VISHNU-cr6nb 5 ปีที่แล้ว

      Sir please share training file

    • @spy5390
      @spy5390 4 ปีที่แล้ว

      Jrur

    • @diptendupaul3070
      @diptendupaul3070 4 ปีที่แล้ว +1

      i like yoy

    • @Lover4all
      @Lover4all 4 ปีที่แล้ว +1

      Sir help chahiye ek formula nahi ho patha hai

  • @rakibulhasan8592
    @rakibulhasan8592 5 ปีที่แล้ว +2

    I had known how to make inventory stock by using vlookup, last I learn making vhocher & automatically save as pdf, that was very important to me, then I think that how can save data of vhocher also in inventory stock at sale sheet sothat it will at a time save as pdf & to my sale entry that automatically adjusted to stock, after seeing this video, I think that how can use it as vhocher sheet you teach us, at last I copy the code of the that you teach record macro from edit macro, and pest to the save pdf button macro , wow it is effective at a time it save as pdg and my sales sheet of stock, thank very much to you good lecture, it is very your teaching process

  • @KaileshHambireIJ-G-
    @KaileshHambireIJ-G- 4 ปีที่แล้ว +6

    Thanks for this video, I was looking similar kind of thing in excell. I really don't need to go to any classes any more to learn excell as i got to learn through your videos. keep it up & God bless.

  • @cachayanadhikari
    @cachayanadhikari 6 ปีที่แล้ว

    Jabardast Sir, excel ko robot banadiye aapne.

  • @mrigankalean
    @mrigankalean 6 ปีที่แล้ว +9

    I was afraid of Excel but wanted to learn as I knew it would be beneficial... the credit goes to bro.... thanks

    • @tusharjain5500
      @tusharjain5500 2 ปีที่แล้ว

      Bro do you know how we can live this sheet on Google sheets

  • @anaabdullah7637
    @anaabdullah7637 2 ปีที่แล้ว +1

    You are the king of excel
    Thanks a looooooooot

  • @aridev009
    @aridev009 6 ปีที่แล้ว +6

    Wonderfully Explained. Saved a lot of time for my repeated work

  • @ravi_trader390
    @ravi_trader390 4 ปีที่แล้ว +1

    Sir really it helped me alot i dont know anything about excel and macro. But u taught in very simple way.

  • @suzanruwali1184
    @suzanruwali1184 6 ปีที่แล้ว +8

    How can i add that save button there is macro excel! I got confused

    • @Rj-to1tw
      @Rj-to1tw 4 ปีที่แล้ว

      Yes wanted to know please do one vedio subscriber urgently needed

    • @samarth_thakur
      @samarth_thakur 4 ปีที่แล้ว +2

      First of all select Right button of mouse
      >there you will find assign macros

    • @madivalbtk6009
      @madivalbtk6009 4 ปีที่แล้ว

      I will not assign macro option when I click right on save button pls tell me how to get that one.

    • @aakashrao1197
      @aakashrao1197 4 ปีที่แล้ว

      There is no assign macro while clicking right button of mouse

  • @KunalSharma-ww5us
    @KunalSharma-ww5us 3 ปีที่แล้ว +1

    Thanks ,, u solved my month long problem

  • @syedikramullah1114
    @syedikramullah1114 6 ปีที่แล้ว +4

    Nice deepak bhai respect from 🇵🇰

  • @MrBhujbalgv
    @MrBhujbalgv 3 ปีที่แล้ว +1

    Thanks for sharing 🙏 very useful information

  • @lorencbellovoda568
    @lorencbellovoda568 6 ปีที่แล้ว +7

    I tried your action many time but data of the Invoices saved at the same rows every tie I select save data and erasing data of previous Invoice and replacing by the new one. So only the data of the new Invoice are saved and the last are erased. What is going on.

    • @labdhishah51
      @labdhishah51 6 ปีที่แล้ว

      Plz reply facing same prblm

    • @anilsathe779
      @anilsathe779 5 ปีที่แล้ว

      macro banane ke bad same day run hota hai, but next day nahi hota.jo macro banaye the wo dukhat hi nahi.
      pl help
      9923316359

    • @jayprakashprasad754
      @jayprakashprasad754 5 ปีที่แล้ว

      Sir Save data ka button kaise ba nega kripya batawe.

    • @ShuubhamSDaabare
      @ShuubhamSDaabare 5 ปีที่แล้ว

      ​ Jaiprakash prasad, I also want to know the same.

    • @aroundmevillage7038
      @aroundmevillage7038 5 ปีที่แล้ว

      i'm also face the problem

  • @ch2oeducation
    @ch2oeducation 6 ปีที่แล้ว

    Sirji aap video bhahut power full banate hai jishe end tak dekhane ka man karta hai...
    Tnx!

  • @luckyrahate6245
    @luckyrahate6245 6 ปีที่แล้ว +5

    Deepak Sir thanks for this video upload for us.
    Sir, is video main aapne "Save Data" ka option kaise create karana hai yah nahin bataya hai. Please is based main humein jankari de.

    • @DeepakEduWorld
      @DeepakEduWorld  6 ปีที่แล้ว

      Just draw a shape from insert tab and assign macro to it

    • @satishjamkaryesrj9391
      @satishjamkaryesrj9391 6 ปีที่แล้ว

      Deepak EduWorld
      save data
      button formula plz

    • @jalilnoor5487
      @jalilnoor5487 6 ปีที่แล้ว

      main bhi yahi pooch raha hon . agar pata chal giya to zaroor share karin thanks.

    • @RKSiNgH-mx9cm
      @RKSiNgH-mx9cm 6 ปีที่แล้ว +1

      @@jalilnoor5487 go to insert option and use shapes u like
      Then insert text on shape
      Right click on shape n select macro... Enjoy.. 👍

    • @nitinjagga2841
      @nitinjagga2841 5 ปีที่แล้ว +1

      DEEPAK JI PEHLI ENTRY JO HUMNE TRANSPOSE AND COPY KI THE USKO KAISE DELETE KARNA HOGA KYOKI WO DUPLICATE ENTRY HO GAYI HAI

  • @abhishekojha440
    @abhishekojha440 6 หลายเดือนก่อน

    Your way of teaching is fantastic 😊😊 I easily understand

  • @bstechnologyrajbiraj1085
    @bstechnologyrajbiraj1085 6 ปีที่แล้ว +9

    Sir Ji,
    Ek sabal Excel me ek invoice bill create kar ke us bill ko ek stock maintain sheet bana kar us bill me Jo Jo item entry karenge wo sare item stock maintain sheet me automatic add hona chahiye to kaise kare sir

    • @DeepakEduWorld
      @DeepakEduWorld  6 ปีที่แล้ว +2

      please wait for next video....

    • @Prince-im2yz
      @Prince-im2yz 6 ปีที่แล้ว +2

      Yesa ek video banaye plz

    • @nanimakana143
      @nanimakana143 6 ปีที่แล้ว

      Yes sir please banayeer

    • @ismailmirza3261
      @ismailmirza3261 6 ปีที่แล้ว

      Sir mujy excel mai antivirus ajye tu kia Kern ?

    • @subhashs5324
      @subhashs5324 6 ปีที่แล้ว

      deepak please explain...automatic billing software with stock maintanance in excel

  • @KDS-v6r
    @KDS-v6r 4 ปีที่แล้ว +1

    MY DEAR BROTHER ,
    NOW I SAID THAT TO SEE THE VIDEO I AM VERY HAPPY AND MANY MANY THANKS TO YOU.

    • @ktv3184
      @ktv3184 4 ปีที่แล้ว

      VISITED HERE MORE UPDATE
      th-cam.com/video/V9XWowxOlWs/w-d-xo.html

  • @sushilaadangale1281
    @sushilaadangale1281 2 ปีที่แล้ว +1

    Best video of excel in excellent

  • @engr.asifzameer3566
    @engr.asifzameer3566 ปีที่แล้ว +1

    Best Teacher

  • @hudip123
    @hudip123 ปีที่แล้ว +1

    thanks for your effort , that's what I tried to do in google sheet. can you make a video to explain the same idea in google sheet. IN ENGLISH PLEASE 🙏

  • @jgvaja2117
    @jgvaja2117 4 ปีที่แล้ว +1

    very useful tips, Thanks

  • @mehboom7495
    @mehboom7495 5 ปีที่แล้ว

    Good morning sir tada tansfer ka ye macro bahuth hi acha he sir main ne ye banaya hun main aap ki har vedio dekhta hun aap ka bahut bahut shukriya sir

  • @amjadshah4395
    @amjadshah4395 4 ปีที่แล้ว +1

    Very good video and very well explained
    Thank you 😊
    Amjad

  • @shileshshukla1567
    @shileshshukla1567 4 ปีที่แล้ว +1

    Kya baat hi bhai.... I never thought it would have been so easy...Good Job Done...

  • @sagarsharma191
    @sagarsharma191 4 ปีที่แล้ว

    आपके सारे विडिओ मेरे बहोत काम आये मेने बहोत कूच सिखा

  • @dheerajvaryani
    @dheerajvaryani 3 ปีที่แล้ว +2

    You are genius. I was trying to do this for a month.

  • @swatsaharachannel6851
    @swatsaharachannel6851 4 ปีที่แล้ว +1

    Nice . Boht zabardast

  • @RajKumar-if4er
    @RajKumar-if4er ปีที่แล้ว +1

    Excellent 10000..... 👍👍👍👍

  • @asimsiddiq475
    @asimsiddiq475 4 ปีที่แล้ว +2

    excellent, your experiment are proof, let me say, you are "King" of Excel.

  • @rahmatullah-syed
    @rahmatullah-syed 5 ปีที่แล้ว +1

    आप बहुत अच्छे शिक्षक भी हो। आप का concept explain करने का प्रतिभा काबिले तारीफ़ है।

  • @indianmonster1445
    @indianmonster1445 3 ปีที่แล้ว +1

    Excellent......... things.....wow

  • @arjung.c8777
    @arjung.c8777 6 ปีที่แล้ว

    all techique are best by eduworld

  • @gangaram0719
    @gangaram0719 3 ปีที่แล้ว +1

    Awesome ❤️❤️❤️❤️❤️
    Sir ye batao ki ek pc ke in database ko dusre pc ke excell sheet ke sath kese automatically LINK ki ja sakti he 📛📛📛📛📛📛📛📛📛📛🛑🛑🛑🛑🛑🛑🛑🛑🛑
    Please urgent he. Thank you

  • @jaywagh4991
    @jaywagh4991 6 ปีที่แล้ว

    Very good vdo bro... Make another vdo on copying data from sheet 1 to sheet 2 with conditional filter. e.g. On sheet 1 ( Master sheet) persons name in column A ( ram, Rahul, ajay, vinod, ram,ajay- repeats same name many times) and some amount in column B... Now if i wright ram with some amount in another column same has to get copied on sheet 2 ( Ram),,, if i wright rahul and amount in sheet 1, same has to get copied on sheet 3... In short - whatever names we wright in sheet 1 should automatically get copied on sheet1(master sheet) or 2 (ram) or 3 ( rahul) etc.

  • @manojupadhyay9543
    @manojupadhyay9543 2 ปีที่แล้ว +1

    Thanks deepak sir 🙏🙏🙏

  • @SamiUllah-gp9lg
    @SamiUllah-gp9lg 2 ปีที่แล้ว

    Than you, Itni saadgi say samjhaya

  • @arshadakbar92
    @arshadakbar92 4 ปีที่แล้ว

    very nice video and yours teaching methed is very Good

  • @vved1495
    @vved1495 3 ปีที่แล้ว

    U r a good trainer

  • @SSIEDUCATIONCHANNEL
    @SSIEDUCATIONCHANNEL 4 ปีที่แล้ว

    VERY VERY NICE MY BROTHER THANKS YOU SO MUCH

  • @amansachdev9651
    @amansachdev9651 4 หลายเดือนก่อน +1

    Same thing I want to do .while seeing your video . I think this video will helpful for me if I understand the macros .how I can reach you .solve my same problem .how I can reach you

  • @pankajsrivastava5962
    @pankajsrivastava5962 6 ปีที่แล้ว +1

    Excellent...Very useful Thanks a lot

  • @sanjupujeri3947
    @sanjupujeri3947 6 ปีที่แล้ว +1

    Nice Deepak very use full

  • @manuv5226
    @manuv5226 4 ปีที่แล้ว

    I am happy to say about your channel is doing well ................. can you place a video about providing formulas in macros

  • @owaismughal7726
    @owaismughal7726 ปีที่แล้ว +1

    superb thanks bro

  • @poojakarn2771
    @poojakarn2771 2 ปีที่แล้ว +1

    Thank you so much Sir

  • @anshtufaniyt
    @anshtufaniyt 5 ปีที่แล้ว +2

    Very good

  • @iamsaood
    @iamsaood 5 ปีที่แล้ว +1

    Wah wah wah jabarsast

  • @banwarifageriaexcelclasses1447
    @banwarifageriaexcelclasses1447 5 ปีที่แล้ว +1

    good very helpful trick .

  • @sjon888
    @sjon888 2 ปีที่แล้ว +1

    This is exactly what I'm looking for but sadly can't understand hindi. I wish there was an english subtitle

  • @bilalshoukat7322
    @bilalshoukat7322 5 ปีที่แล้ว

    Deepk apki videos bohat informative and helpful hain. I learned a lot from you.
    Plz solve my another problem. Problem is Jesy accounting software me journal entry save krty hain to wo alag alag accounts me automatically shift ho jati hai. Exel me ye kesy possible hai. Sb accounta mery pas alag alag hain. separate sheets pe

  • @yayamayofficialvlogs
    @yayamayofficialvlogs 3 ปีที่แล้ว

    thank you sir for connect and sharing

  • @nitcomputer3564
    @nitcomputer3564 6 ปีที่แล้ว +1

    Very nice video

  • @vivekgoswami5820
    @vivekgoswami5820 4 ปีที่แล้ว

    Very good presentation. Thank you.

  • @shivbhure
    @shivbhure 6 ปีที่แล้ว

    Thank you for information.... Good Video

  • @b.alammamun6933
    @b.alammamun6933 2 ปีที่แล้ว

    Really awesome !!! thanks brother

  • @csadanandancsadanandan8132
    @csadanandancsadanandan8132 3 ปีที่แล้ว +1

    Very good usefull

  • @walemohammadkhattak6886
    @walemohammadkhattak6886 6 ปีที่แล้ว

    Nice and informative information

  • @navaskollam4473
    @navaskollam4473 5 หลายเดือนก่อน

    Very good explanation

  • @excelbyspsr
    @excelbyspsr 5 ปีที่แล้ว +1

    Very nice bro Thank you

  • @nikunjpatel4915
    @nikunjpatel4915 4 ปีที่แล้ว +1

    Really good explanation
    Kya hum aese hi category wise sheet 2 , sheet 3 me data transfer kar sakte he
    Jaiseki sheet 1 me A, SHEET 2 ME B .... AN ONWARDS

  • @kgnkhan111
    @kgnkhan111 5 ปีที่แล้ว +1

    Very very very very thanks

  • @HeenaSpace
    @HeenaSpace 2 ปีที่แล้ว +1

    Can i save data in entirely different workbook. As you showed in the same workbook.

  • @shankarganesh5196
    @shankarganesh5196 4 ปีที่แล้ว

    THANK YOU SOOOOO MUCH BRO ..AWESOME VEDIO

  • @MohdIrfan-du7zk
    @MohdIrfan-du7zk 6 ปีที่แล้ว

    Excellent Deepak...

  • @fanikamal123
    @fanikamal123 5 ปีที่แล้ว +1

    Best video it helps me a lot... thanks Man @deepak EduWorld

  • @insideladakh4884
    @insideladakh4884 5 ปีที่แล้ว +1

    Thanks very useful...

  • @TATA_NEXON_TURBOCHARGED_ENGINE
    @TATA_NEXON_TURBOCHARGED_ENGINE 6 ปีที่แล้ว

    Excellent formula

  • @Dulquersalmaan_369
    @Dulquersalmaan_369 9 หลายเดือนก่อน

    Thanks bruh u saved me !!

  • @ramachandrannatarajan4234
    @ramachandrannatarajan4234 5 ปีที่แล้ว +1

    Excellent

  • @jitenderyadav7736
    @jitenderyadav7736 3 ปีที่แล้ว +1

    DEEPAK JI ....EK VIDEO IS TOPIC PR BNO KI AGR APNI EK SHEET( EMPLOYEE KI NAME , AGE , SALARY) ME KOI DATA ALREADY SAVE HAI OR YADI HUM SECOND NEW SHEET ME US FIRST SHEET KA KOI DATA LEKE AANA HO TO KAISE LAYE...MTLB SECOND SHEET ME EMPLOYEE KA NAME TYPE KRE OR BAKI USKI DETAILS (AGE , SALARY ) AUTOMATICALLY AA JAYE...PLZZ ...AGR KOI VIDEO ALREADY HAI TO LINK SAHRE KRDO...

  • @pradeepbeherag.3418
    @pradeepbeherag.3418 5 ปีที่แล้ว +1

    Very very useful trick's sir

  • @evansadip1452
    @evansadip1452 3 ปีที่แล้ว

    Deepak Sir, you are so talented and unique guy.

  • @kaarigarboutiqueshahdab.3307
    @kaarigarboutiqueshahdab.3307 5 ปีที่แล้ว +1

    Deepakji I m great fan of u

  • @jalilnoor5487
    @jalilnoor5487 6 ปีที่แล้ว +1

    It is very fantastic clip and very easy to learn from this video but one step was missed (how to make the save button).

    • @DeepakEduWorld
      @DeepakEduWorld  6 ปีที่แล้ว

      Just draw a shape from insert tab and assign macro to it.. By rjght clicking on shape...

  • @kgnkhan111
    @kgnkhan111 5 ปีที่แล้ว +1

    Super sir

  • @debikash4128
    @debikash4128 5 ปีที่แล้ว +1

    Very useful video for me.Thanks a lot for your hard work.Sir Please tell me, How to do this in multiple sheet?

  • @alightmotion.xml.
    @alightmotion.xml. 3 ปีที่แล้ว +1

    Good job

  • @satpalkatyal9950
    @satpalkatyal9950 5 ปีที่แล้ว +1

    Sir, It is a good video. Please also share how we can delete or edit a record without using VBA

  • @zubairakbar5385
    @zubairakbar5385 6 ปีที่แล้ว +1

    weldon sir goood work.....thanks for sharing this vedio...

  • @prashantmeshram3435
    @prashantmeshram3435 4 ปีที่แล้ว

    thanks for the solution sir

  • @milindmore6540
    @milindmore6540 6 ปีที่แล้ว

    Nice video sir for learn

  • @asimsarwar48
    @asimsarwar48 4 ปีที่แล้ว +1

    Honestly you explained very nice easy 👍.
    As you teach in this video how to transfer data 1 sheet to another sheet. Would you please give me a tips how to transfer data 1 sheet to another folder. Like saving path is c:\mydocument\xyz\etc. thanks in advance 👍

    • @DeepakEduWorld
      @DeepakEduWorld  4 ปีที่แล้ว

      I ll publish video ASAP 😊👍

  • @santoshagre9550
    @santoshagre9550 2 ปีที่แล้ว

    Thanks a ton bro. FInally i to made it

  • @RajendraPatel.
    @RajendraPatel. 6 ปีที่แล้ว

    You are real Hero Deepak ji.!! nice tutorials!! 👍

  • @SALEEM0409
    @SALEEM0409 3 ปีที่แล้ว

    Fantastic job

  • @pervezkhn
    @pervezkhn 5 ปีที่แล้ว

    Nice video, dear make a video on journal, ledger, Trial Balance, Profit and Loss, Balance Sheet and Cash flow statement.
    so my question is that when i enter transactions in journal then it will automatically create the ledger, Trail Balance .........etc reports so please make a video on this and also filter on these reports

  • @caaman93
    @caaman93 4 ปีที่แล้ว +1

    Thanks bro

  • @hmsir4861
    @hmsir4861 6 ปีที่แล้ว

    Sir Please Make a Video how to Calculate MFD,exp,Inventory Control, Of Pharma distribution business in excel..It's Very Important sir..Please Make a Video about this topic

  • @sunitadahibhate5626
    @sunitadahibhate5626 6 ปีที่แล้ว +1

    Ausom video it is actually useful thanx sir

  • @TIE-TakeItEasy
    @TIE-TakeItEasy 3 ปีที่แล้ว

    When I set macro and started to work on it, it was fantastic, saved it as per the directions in this clip, reopened the file and saw there was nothing! right clicked the button>assign macro....but the window was empty.

  • @arghyadipkoley77
    @arghyadipkoley77 6 ปีที่แล้ว

    NICE PROJECT SIR

  • @rajendramirgal4341
    @rajendramirgal4341 6 ปีที่แล้ว

    Very nice sir.

  • @AnilKumar-go7hj
    @AnilKumar-go7hj 4 ปีที่แล้ว

    Very good sir very nice video sir

  • @sanjaynale8690
    @sanjaynale8690 6 ปีที่แล้ว +1

    SUPER , IT WORKS !

  • @SANTOSHKUMAR-kj3hv
    @SANTOSHKUMAR-kj3hv 5 ปีที่แล้ว +1

    Nice video sir

  • @saklinsk4618
    @saklinsk4618 2 ปีที่แล้ว

    Thank you, sir. 😊
    .
    ..
    ...

  • @mytechnosupport269
    @mytechnosupport269 3 ปีที่แล้ว +1

    Please give modified video for Google sheet as macro recording is diffrent from Excel ......thanks

  • @asgarali14
    @asgarali14 6 ปีที่แล้ว +1

    Thank you so much Deepak ji. aap ka bahoot bahoot dhanyavaad

  • @sonu4537
    @sonu4537 4 ปีที่แล้ว +1

    Thank u sir