How to Automatically Transfer Data from one Sheet to Different Sheets in Excel (Hindi)

Рет қаралды 20,459

9 ай бұрын

How to Automatically Transfer Data from one Sheet to Different Sheets in Excel (Hindi)
In this video tutorial you will learn how to transfer data from one sheet to different sheets. A new teqhnique has been applied to make it possible. No Excel Functions and VBA are used. This simply means that even if you have just started learning Excel, you can do it easily. You just have to click a few buttons as per the steps mentioned in the video.
So watch the video.
✅For more videos please subscribe our channel: / powerexbyjitendra
Sample workbook:
==============================
docs.google.com/spreadsheets/...
==============================
Other Video on Same Topic:
Transfer Data Customer Wise from One Sheet to multiple sheets in excel (Hindi)
• Transfer Data Customer...
------------------------------------------------------------
Playlists of our top videos:
1. Stock Management System in Excel
• Stock Management Syste...
2. Advanced Excel Formulas
• Advanced Excel Formulas
3. Awesome MS Word Videos
• MS Word
4. Conditional Formatting in Excel
• Conditional Formatting
5. Data Entry Form
• Data Entry Forms
6. Custom Number Formatting Tricks
• Custom Number Formatting
7. Recent Uploads
• Recent Uploaded Videos
8. Best Excel Shortcut Keys
• Best Shortcut Keys in ...
9. Power Query Tutorials
• Advanced Excel Power Q...
10. MIS Report in Excel
• MIS Report
11. Excel PivotTable
• Excel Pivot Table
-------------------------------------------------------------------
Video is created by Jitendra
Published on Powerex by Jitendra
Language of this tutorial is Hindi.
#transferdata
#powerexbyjitendra
#excel
Subscribe on Telegram:
t.me/powerexbyjitendra
Contact Us:
Instagram: kumarjitendra11...
Facebook : / powerex-by-jitendra-10...
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.
Thanks

Пікірлер: 26

@muhammadkaleem4676 6 ай бұрын

Very good excellent work, es video k andaar 2 method sy Data transfer bataya hai ❓

@PowerExbyJitendra 6 ай бұрын

Thanks a lot

@bhajanlal5458 7 ай бұрын

Sir bahut videos dekh Lee hai aap ki videos mein easily samajh aata hai .Sir Mera ek question hai ki ye entries to Jo data feed hai unki hai agar koi new. customer ki entries karni ho aur uski alag file bhi create ho Jaye to kese hoga plZ confir me

@saifcolins6485 7 ай бұрын

Excellent! Thanks for your great tutorial.

@PowerExbyJitendra 7 ай бұрын

Thanks

@rajeevsinghbais1727 Ай бұрын

Awesome, simplest explanation

@PowerExbyJitendra Ай бұрын

Thank you so much

@ManojGupta-nl8fj 3 ай бұрын

सर जी आपने बहुत ही सरल तरीके से समझाया है। क्या ये सीटें ऑटोमेटिक हो सकती है? क्या summary sheet पर डाटा को लाने के लिए एक फार्म बने और उसके माध्यम से डाटा summary sheet से लेकर सभी शीटों में ट्रांसफर होकर रिफ्रेश होता रहे।कृपया इस पर मार्ग दर्शन देवें। यदि बनी हुई इस फाइल में किसी नए कस्टमर को एड करना हो तो क्या करेंगे।

@ntr070901983 5 ай бұрын

Hello Bro, Excellent. You have explained it very well. I have a question here. Just like you made I want to make one sheet for another purpose. My question is here I am entering data in the summary sheet and it will be saved in the summary sheet and the other respective sheets. Is there any option that if i delete the data or row from the summary this should not effect other respective sheets that means summary sheets whould be used as a data adding and deleting as per my requirement but the data from the summary sheet which was saved in the other respectives should not be deleted. can you give me any suggestions. thank s in tonnes

@abcdefghijkl396 3 ай бұрын

Very nice

@PowerExbyJitendra 3 ай бұрын

Thanks

@rajeevgosavi4514 5 ай бұрын

Thanks Bro for your yet another excellent video which has taken care of my constant worry. It has really helped me. However If I wish to update on a monthly basis ,i.e I have a requirement of creating such data every month in a respective monthly worksheets , how do I refresh it.

@PowerExbyJitendra 5 ай бұрын

Thanks a lot

@payamehussain2052 9 ай бұрын

new customer agar add kren tu entries automatic ho jay gi???

@sajujacob6035 7 ай бұрын

Sur, Instead of transferring data to different individual sheets how to update in single sheet having different customer headers?

@tariqmahmood7881 2 ай бұрын

If a new customer added then what will be the shortcut method?

@azizkhan-dw5fh 9 ай бұрын

Please tell me how to merge different files of excel or csv in one file. Regards

@PowerExbyJitendra 9 ай бұрын

Please checkout our playlist of Power Query.

@ramizmahadik5076 7 ай бұрын

Is there any other option instead of refreshing everytime

@ManishShori 9 ай бұрын

I am using Excel 2013 and I unable to find From Table/Range in Data. Neither I find it in Microsoft 365. Is it not available in both, if yes then in which version this option is used

@PowerExbyJitendra 9 ай бұрын

Power Query is available as a free add-in on Excel 2010 and 2013, which you can download from Microsoft's website. In office 365 it is already installed with same options.