How to Automatically Transfer & Save Data From One Sheet to Another in Excel || HINDI
HTML-код
- Опубликовано: 27 сен 2024
- how to automatically transfer Save data from one sheet to another in excel Hindi -easily Record & Save data and transfer it to another sheet - learn how to auto save/record data entries in excel 2007 2010 2013 2016 2019 without any formulas just using macro in excel 2021
#Excel
#Datatransfer
#excelmagictrick
#macro
transfer data from one excel worksheet to another automatically date wise daily ... watch this video : • How To Automatically T...
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
#DataTransfer
#AdvancedExcel
#ExcelTricks
#ExcelTipsandTricks
#ExcelTutorial
#LearnExcel
#Excel_Formulas_and_Functions
#Excel_online_course
#deepakeduworld
#Microsoft_Excel
#How_To
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 TIPS ►
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
Thanks for watching
DEEPAK NEHRA
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
What to do to transfer all rows other than zero values into another sheet
Sir please share training file
Jrur
i like yoy
Sir help chahiye ek formula nahi ho patha hai
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.
Jabardast Sir, excel ko robot banadiye aapne.
I was afraid of Excel but wanted to learn as I knew it would be beneficial... the credit goes to bro.... thanks
Bro do you know how we can live this sheet on Google sheets
MY DEAR BROTHER ,
NOW I SAID THAT TO SEE THE VIDEO I AM VERY HAPPY AND MANY MANY THANKS TO YOU.
VISITED HERE MORE UPDATE
ruclips.net/video/V9XWowxOlWs/видео.html
Wonderfully Explained. Saved a lot of time for my repeated work
You are the king of excel
Thanks a looooooooot
Nice deepak bhai respect from 🇵🇰
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
How can i add that save button there is macro excel! I got confused
Yes wanted to know please do one vedio subscriber urgently needed
First of all select Right button of mouse
>there you will find assign macros
I will not assign macro option when I click right on save button pls tell me how to get that one.
There is no assign macro while clicking right button of mouse
Sir really it helped me alot i dont know anything about excel and macro. But u taught in very simple way.
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
please wait for next video....
Yesa ek video banaye plz
Yes sir please banayeer
Sir mujy excel mai antivirus ajye tu kia Kern ?
deepak please explain...automatic billing software with stock maintanance in excel
You are genius. I was trying to do this for a month.
excellent, your experiment are proof, let me say, you are "King" of Excel.
♥️
आप बहुत अच्छे शिक्षक भी हो। आप का concept explain करने का प्रतिभा काबिले तारीफ़ है।
Your way of teaching is fantastic 😊😊 I easily understand
Than you, Itni saadgi say samjhaya
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 🙏
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
Best video of excel in excellent
Nice . Boht zabardast
आपके सारे विडिओ मेरे बहोत काम आये मेने बहोत कूच सिखा
Best Teacher
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
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...
Can i save data in entirely different workbook. As you showed in the same workbook.
Excellent 10000..... 👍👍👍👍
Excellent...Very useful Thanks a lot
VERY VERY NICE MY BROTHER THANKS YOU SO MUCH
Excellent......... things.....wow
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
Thanks deepak sir 🙏🙏🙏
very nice video and yours teaching methed is very Good
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.
Can we do the same in attendance for marking present Absent by selecting Day month and employee ID? Please guide me, how?
Please give modified video for Google sheet as macro recording is diffrent from Excel ......thanks
This is exactly what I'm looking for but sadly can't understand hindi. I wish there was an english subtitle
sir same invoice ke liye video banao na
Thank you so much bro. Respect from Bangladesh.
good very helpful trick .
🤗😊😊
Thank you so much Sir
U r a good trainer
thank you sir for connect and sharing
all techique are best by eduworld
superb thanks bro
Very good
Dear Bro thanks for this kind of videos & plz give suggestion about " next data save karne par pahle se register data ko delete kar deta hai sath hi class nahi ati hai" plz
plz reply sir
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
Very good explanation
hello depak ji aapka ye video bahut he achha he or aapne is video me data entry work ko bahut accche se samjaya he lekin isme save data ke option ko kis tarah se create kiya he please usko bhi video ke madhayam se bataye
this is just a picture. add any picture using insert option
Nice Deepak very use full
Very good usefull
Sir can you plz make a video on how to make this attendence sheet live on Google sheets 🙏
Nice and informative information
Please make video for POS machine Including INVENTORY
Very very useful trick's sir
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
ruclips.net/video/lIwR6ewAeR8/видео.html
Thanks😊
How to make online change data storage in excell sheets. Please make video on this topic.
Asap 👍
It is very fantastic clip and very easy to learn from this video but one step was missed (how to make the save button).
Just draw a shape from insert tab and assign macro to it.. By rjght clicking on shape...
Thank you for information.... Good Video
Sir, It is a good video. Please also share how we can delete or edit a record without using VBA
Hello Sir
Excel ki file ko alag sey excel mein save karney ka formula bhi btado
Aapney kaha tha ki jald he video bna raha hun...
I waiting ur video
Excellent Deepak...
THANK YOU SOOOOO MUCH BRO ..AWESOME VEDIO
Amazing tricks.......
Sir sheet 2 ki entry ko koi delete na kar sake easi koi trick he kya ?????? ?????????
This is exactly what I want to achieve. But I don't know Hindi language. Is it possible to translate into English or have an English subtitles? Thank you so much.
Really awesome !!! thanks brother
You are real Hero Deepak ji.!! nice tutorials!! 👍
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 👍
I ll publish video ASAP 😊👍
Thanks bruh u saved me !!
Excellent
Deepak ji Mera Ek question tha aapse phle bhi puchna different size ko merge cells hai toh usme mjhe formula copy krna hai toh wo kaise krenge.... Wo bhi bina unmerge Kiye hue.... Please btaiye jisse mera kaam aasan Ho jaye
Can u tell me how prepaid ledger automatically from entery in excell
Very good presentation. Thank you.
How to Preapre Employe ID card bro is par video banao apki Video quality b achii hoti hai ap step by step guide krte.. Thanks .. !!! 😎😎😎
Ausom video it is actually useful thanx sir
BHAI BEST KYA AAP IS DATA ENTRY KO XML MAI BANA SAKTE HAI
sir Ji thanks for your information.
your every vedio is useful and informative.
but I am unable to create save button in automatic save data
Pls inform or make vedio how to make save button
thanks for the solution sir
Sir , Many Many Thanks to great help us
Sir I want the data to be saved in an existing table.(with a search) Is it possible
Good work what about if we have to deleat any entry.
Best video it helps me a lot... thanks Man @deepak EduWorld
👍👍👍
Sir awesome lesson ......I have one prblm sir , it is one month data should carry forward to next month,it means first month ka data add hoke next month data par display hona chahiye...help me sir
Good job
Super sir
Sir kindly make a video on weighbridge scale software on excel...how to get the data on excel load and tera load on invoice save...
Thanks a ton bro. FInally i to made it
Thanks for video this is very useful for some of my work !!!!
weldon sir goood work.....thanks for sharing this vedio...
Thank u sir
DEEPAK Bhai jo aap ne fully automatic attendence sheet create ki thi us ka data submit kar k bata du plz. thankyou
New attendance sheet for 12 months... ruclips.net/video/0Bdc1XftAw/видео.html 👍👍👍
साथ ही video के स्क्रीन मे दिखाई दी गयी रेड कलर की save data बटन कैसे insert करते है, प्लीज बताये.
Nice one deepakji, suppose kuch online data update hora hai 1st sheet mai ek row mai 10 columns mai or same 10 column har 10 min baad wo data niche wali Row mai save hota rahe auto matic
Macro will do it... Vba code type krna padega..
Very nice sir.
Deepak sir ye micro record kake ho jata par blank entry hone se rokane ke liye kya code use kare
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.
Hi dear you are video is so useful but I have one question how do I keep formula I mean when I hit the save data button everything transfer to the second sheet but I wanted to keep date and time updated because I have to put the date and time again, I wanted to keep the date and time formula
Thank you, sir. 😊
.
..
...
Hi please upload videos for data search and edit in userform