Split Data into Multiple Files | VBA Projects in Hindi

Split Data into Multiple Files | VBA Projects in Hindi
For online classes, please contact us at 93100 73387
Sometimes, you need to split data from one master sheet to multiple files.
🔴 Subscribe for more videos just like this: bit.ly/2PUQwXk
🎧In this video, you will learn
►How to split data from one file to multiple files
►How to split data from one sheet to multiple files
►How to use offset method in VBA
►How to use resize method in VBA
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
🖥️Video Summary 👉
📋Split Data into Multiple Files→
It's very easy to split data from one master sheet to multiple files. To split data from one master sheet to multiple files, you need to follow the below steps:-
(1). Get a unique Region Name by using an advanced filter and paste it somewhere else in the same sheet
(2). Get all unique region names one by one in for each loop
(2). Apply Filter on sales data by region
(3). Add a new workbook
(4). Copy region-wise filtered data
(5). Paste data in a new workbook
(6). Save all created files in the AllFiles folder
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
Hope you found this video useful. Please like, share, and subscribe to our channel. This will motivate us to create more good content. Thanks!
🎬Watch our most recent videos: / automationfever
💜You Might be Interested in (Free Tutorials):
Basic VBA Tutorials (Hindi)👉 • Why Should Learn VBA |...
Advanced VBA Tutorials (Hindi)👉 • Send Outlook Mail in V...
Excel VBA Projects (Hindi) 👉 • Add & Change Sheet Tab...
VBA Outlook Automation (Hindi)👉 • Send Outlook Mail in V...
Excel Tips & Tricks (Hindi)👉 • Copy From Clipboard - ...
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
🎧Do watch our Other VBA Videos (Hindi) 👉
Send Outlook Mail in VBA 👉 • Send Outlook Mail in V...
Format Email Body in VBA 👉 • Format Email Body in V...
Add Signature in VBA 👉 • Add Signature in VBA |...
Add Attachment in Mail Using VBA 👉 • Add Attachment in Mail...
Insert Image in Email Using VBA 👉 • Insert Image in Email ...
Add List On Email Using VBA 👉 • Add List On Email Usin...
Add Unordered List on Outlook Mail 👉 • Add Unordered List on ...
Using RTF Property 👉 • Using RTF Property | V...
Create RTF Mail using Word Editor 👉 • Create RTF Mail using ...
Paste Excel Range To Mail Body 👉 • Paste Excel Range To M...
Inserting Chart in Email Body 👉 • Inserting Chart in Ema...
Inserting Pictures In Outlook Email 👉 • Inserting Pictures In ...
Send Bulk Emails Using VBA 👉 • Send Bulk Emails Using...
Copy Range As Picture To Outlook Mails 👉 www.youtube.co... -vdXw0NnGLM
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
-------------------------------SOCIAL-------------------------------
🛠️ If you have any doubt or query, drop us an email: [e-mail]
🌎Website: www.automationf...
👥Facebook: / feverautomation
🐦Twitter: / automationfever
📸Instagram: / automationfever
📕Blogger: automationfeve...
----------------------------------------------------------------------
#filesystemobject #splitdata #excelvba #learnvba #vbatutorialsinhindi #automationfever #splitdataintomultiplefiles #foreachloop #offsetmethod #resizemethod #fso #vbaprojects