Save Time with This Excel Data Transfer Tips - Master Sheet to Multiple Sheet Automatically
Вставка
- Опубліковано 25 бер 2020
- excel users can Save Time with This Excel Data Transfer Tips - Master Sheet to Multiple Sheet Automatically
dosto is video main aap seekhoge ki master sheet ka data hum alag alag sheets main automatically kaise transfer karange - for example humare paas customers ki sales ka data aek sheet par hai or hum chahate hain ki sabhi customers ka data automatic alag alag sheet mai transfer ho jaye (excel data transfer between sheets ). is video mai ye amazing excel magic trick aap seekhoge. advanced filter or macro ka use karke master sheet to separate sheets ( multiple sheets) main hum data aasani se transfer kar paynge - excel transfer data to another sheet #exceltips #macro #exceltricks
excel sheet tips video : • Excel Sheets Pro Tips ...
How do I link multiple sheets to master sheet in Excel?
How do I split data from a worksheet into multiple worksheets in Excel?
Excel copy data from one sheet to another automatically
How to transfer data from one sheet to another in excel using macros
Must Watch These Advanced Filter Videos :
Advanced Filter Video : • Advanced Filter in exc...
Dynamic Advanced Filter : • How To Make ADVANCED F...
Automatically Transfer Daily Data To Another Sheet In Excel : • How To Automatically T...
Videos on Macro :
How to use Macro : • How to Use Macro in Ex...
Create Automatic Excel Reports Using Macro : • How To Create Automati...
Download Training File: drive.google.com/open?id=1BHn...
Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day...
Deepak EduWorld Playlist's:
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's in excel ► goo.gl/dFhg54
Subscribe to Deepak EduWorld ► / deepakeduworld
Follow on Instagram ► / deepakeduworld
Like my Facebook page ► / deepakeduworld
Follow on LinkedIn ► / deepakeduworld
We Always Provide Useful & Helpful Content On The Deepak Eduworld UA-cam Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
Really Helpful and useful Sir!
I really need this video.
Thank You so Much Sir!
I was just working on a lengthy process but now i am thinking of using this method 👍👍
Thanks for sharing this knowledge 🙏
शानदार जानदार🙏
Thank you so much it's really excellent class
Superb, many thanks for sharing your knowledge Mr. Excel. I love watching your videos 🙂.
Thx for video uploading. B4 6 years I was looking for mis classes in Delhi. Today I found it in my home small village in uttrakhand. Thx a lot
Learn EXCEL VBA from scratch in urdu...Nil to skill level
Speechless work
wah Deepak wonderful, thanx
Amazing Sir.... Very informative n beautifully described 🙏.... I never miss ur videos....
Its very useful tips. We can make automatic Sales Invoice from Sales Data or Transaction by using these useful tips. Thanks a lot sir.
Thank you so much for this video. This will be very helpful for my work. stay blessed!
thank you Deepak ji. Apka samjhane ka tarika sabse behetar.I have learnt lots from you.
Really helpful sir,
Sir, please make a video such as: ek excel sheet jisame employee name and unaki attendance hai hourly ek hi sheet me ek year ka data hai usame hum week wise ya month wise data select karna chate hai ek alag sheet me vo bhi date selection ke adhar par jaise hume 1 january se 8 january tak ka Ram name ke person ki total hours attendance chahiye to automatic excel sheet me kaise nikalenge (Kabi kabi humako select karna hota 01.01.2020 to 01.08.2020 to is date ka data sum hokar aa jaye.
So I request you to please make a video sir.
Very Useful...
Keep Sharing Knowledge...
Thank you...
Sir mast he.
Isi ka intezar tha kab se mil nahin raha tha kahin
🙏👌👌
Learn EXCEL VBA from scratch in urdu...Nil to skill level
बहुत बहुत धन्यवाद SIR
मैं कई दिनों से एक EXCEL SHEET पर काम कर रहा था, लेकिन बन नहीं पा रही थी
आपके वीडियो से फटाफट बन गई
*THANK-YOU VERY MUCH SIR*
mene same to same process kiya lekin error bata raha he
Really great sir.Learned a lot.Pl keep this going on to learn new things.Stay blessed sir.
EXCLE VBA is also much powerful to deal with lot of data.... Learn it
Deepak ji
Your macro part is very good understandable to each person.
But I want create customers sheets by using inputbox macro not by manual.
Very good knowledge sir baki sub to tuter hain per aap mere guruji ho
Thanks from heart
♥️😊
Hello Sir, I have learned a lot from the video axle and power point you have made and I am working in a good position in an office, so sir, you are requested to make some videos on SAP ERP , I will ask you I request you to make a video on SAP ERP again, thank you sir.
बहुत काम की है, धन्यवाद
Bahot achhi jankari di hai data transfer ki thanks
Best , useful video. Thank yo so much sir, God Bless .
How to create form 16 in excell from tax calculation sheet
Please make a video.
Great work very helpful
Farhan from Pakistan 👍
Bro apka channel super👌👌...excel sikhne ko milte he...bro thanks
amazing & unique
Apka Video Bahot Accha tha. Thank you so much.
Thank you sir apk bajase Maine bohot Kuch sikha excel Mai ❤️❤️😍😘
Excellent excel trick i have regularly watch your all vedio. I need help if stock report also automatic from sales register entry. If this is updated it will be excellent vedio nobody require tally for small business.
Thank you
Thankyou sir, it was awesome.
Your are amazing.... you just solved my biggest problem..
Aap bahut achhe se samjhate ho aur step by step
So nice of you
very use full
thank you
keep going
Thanks for sharing your knowledge 👍
Your explanation very interesting and subject orientation. Namaskaram
Hatsoff sir
Thank you sir
Aapkee vedio hmai expert bna daitee h
Yehi video me dhund raha tha. Thanks Mr. Depak ji
DEEPAK JI VERY NICE AND USEFUL TRICKS BY SIMPLE METHOD THANKS GOD BLESS YOU
Deepak.ji....
Apke voice bht hi achi hai aur apka anergee bhi...
Thanks
Keep educating us. Thank you Deepak jee ..God bless you..
Nice detail Deepak sir।
@GREAT VEDIO
Have been searching for along time
Really amazing
Hello Deepak.this is Rohit here from mumbai...thank you so much..ur doing great job.
You call macro for each (3 macro) sheets in work book... can we record only 1 Macro for all 3 sheets and get same data...
please help...
I think sir is video ke liye maine apko what's app kiya ....
Nice thank you
Thank you Deepak sir … amazing video and really helpful….
very use full Excel Trick i m very happy with this
दोस्तों ये वीडियो आपको कैसा लगा ? आपके मन में जो भी विचार है हमें Comments मै लिख के जरूर बताएं 🥰
*My New Channel :* bit.ly/3qFrbl5
*Complete Microsoft Word Tutorial :* ua-cam.com/video/Xkq0-xXAj48/v-deo.html
*Complete Powerpoint Tutorial :* ua-cam.com/video/OekrBhNybP0/v-deo.html
*Xlookup Complete Tutorial :* ua-cam.com/video/0LjfRVD7srU/v-deo.html
*Vlookup Complete Tutorial* : bit.ly/2K0C1Sb
*Excel All Formulas :* ua-cam.com/video/C9y53fedo04/v-deo.html
Sir vba karva diziye...... Ab to...
Sir aap great hey excel ka boss sir app ki course laiya na paid course for advanced learner
Sir word excel PowerPoint ki PDF file par puri jankari de . please
Reply soon . please
सर, आप का समझाने का तरीका बहुत अच्छा लगा।
But सर एक error आ रहा है, जैसे ही दूसरी या तीसरी शीट पर जाते हैं तो
Run-time error '1004':
Application-defined or object-defined error
दिखता है
Please कुछ बताएं सर
Great video....Sir macros ke uses pe ek video banaiye
Very Useful Knowledge & Trick very big Thanks
Bhai you are simply superb
Excellent video. Very much useful. Thanks a lot
Bahut badhiya Bhai, thank u
Aapka video super rahta hai bhai mai computer oprater ka job karta hu mere liye bahut helpful rahta hai thanks...
Very Very useful trick.
Thanks Sir. Its really helpful for me.
Very much helpful video. Thank you very much.
Sir your all video very knowledgeable and useful thank you so much Sir
Deepak ji apke sare video bht ache hote hain
बहुत अच्छा सिखाते हो सर👌👌👌👌👌👌👌👌👌👌👌👌👌🙏🙏🙏🙏🙏🙏🙏🙏🙏👍👍👍 बहुत बहुत धन्यवाद सर इतना डिटेलली सिखाने केलीये..
😊
Very helpful.Thanks Deepak for Sharing
thank you very much dude for this video...
Unit price aur total ke sath agar last do column aur ho jaise amount paid and balance phir mujhe baki ki sheets par agar sirf usi customer ka balance chahiye kyunki total balance ka koi matlab nahi hai mujhe sirf particular customer ka balance amount dekhna hai usse paise lene ya dene ke liye to kya kuch ho sakta hai sath hi baki ki sheets mein mujhe customer ke naam ka column nahi chahiye kyunki usme to bas ussi customer ki entries ho hongi to us column ka kya matlab. Baki Video bahut informative hai. Bas mujhe ye apna ek kaam karne ke liye janna hai
Kar diya like
Really Smart work. Great Effort!
Thank you for explaining it so nicely.
Excellent training
Superb knowledge share to us
Excellent knowledge 👍
Thank you
Vry nice video sir
👌👌👌👌👌
Bhut hi helpfully video hai sir
Mujhe bhi aata hai
Love you sir have good day
Jay hind vande matram
आप का समझाने का तरीका बोहोत अच्छा है
मै खुद एक 4 कक्षा पास हु
आप व्हिडिआे देखकर बोहोत सिखता हू
Very useful video and explain deeply and picture wise for better understanding step wise nice sir
Awesome tricks bro. Thanks a lot.👍👌
Thank you sir, very nice taught.
Learn EXCEL VBA from scratch in urdu...Nil to skill level
Lovely excel management
EXCLE VBA is also much powerful to deal with lot of data.... Learn how?
Hello sir very useful video. Thanks for this effort to teach us new things everytime 😊. But one error is coming that A table can't overlap another table why it's coming ?
शानदार
Sir aap bahut achha samjhate hai thank you.
♥️
Awesome, thank you
Learn EXCEL VBA from scratch in urdu...Nil to skill level
Sir your videos very useful in daily office work Thank You verymuch also in those video I have occur an compile error and micro not running so Make one video on how handle these types or errors Thank You one again
Superb sir ji
am waiting for such a video from you.... Now i got it very thankful to you sir ji
Deepak Excelente information
Good work!
Great and Amazing tips sir😊😊😊
Really amazing 👍
excellent work, Thanks and regard.
Learn EXCEL VBA from scratch in urdu...Nil to skill level
nice workout
Deepak,
Excel does exactly as you explained in the video. Thank you.
if we want sum of the values at the end of sheet, what should we do?
sir i did the same thing but my data is not possible different items are from different places
Deepak I really appreciate your very nice helpful videos…👍👌
Thanks
Sir agar hamare paas 100-200 customers hai tab ek ek karke micro record karna fir sheet PR active karna bahut time taking ho jayega
Koi aisa tareeka jaroor hoga jisse ek baar me hi sab sheets PR micro lag jaaye aur active ho jaye
Thanks, it's a very good achievement, how to save it, for re open on the same formate?
your goodness are creating samething new .
Sir. Aap ka method bohuti accha laga . Aapse ok request hai.. cash book aur ledger automatically excel main kum kaise kare, Wo agar dikha te to bohut mehebani hogi
Very Helpful ❤
Super video 👌👍
I was searching for this information from last few days
Perfectly explained
Love you
बहुत बहुत बहुत फास्ट हैं
JABARDAST