How to Convert Multiple Excel Sheets into Separate Excel Files – Doston is video mein maine apko bataya hai ki kis tarah aap MS Excel ki Workbook mein jitni worksheets hai unhe Excel files mein convert kar sakte hain. Agar aap normal method se apni sabhi Excel Sheets ko Excel file mein convert karenge to apka bahut jyada time waste hoga aur Excel mein koi aisa function nahi hai jiski madad se hum is kaam to kar sake. To is kaam ko karne ke liye humne ek VBA code ka use kiya hai, jiski madad se aap multiple excel worksheets ko excel files mein convert kar sakte hain. Hope aapko ms excel ki ye magical trick bahut pasand aayegi.
🔥Buy our MS Excel Course –
Download VBA Code –
Download Excel File –
Video Link- Split Data from Master Sheet to Multiple Sheets –
Following topic covered in this video :
How to convert excel worksheets into Excel Files
How to make individual excel files of all excel sheet
Excel sheets ko excel file mein kaise convert karein
How to split each excel sheet into a separate excel file
How to split each spreadsheet into a separate excel file
How to split each excel sheet into a separate excel file using VBA
How to Convert Multiple Excel Sheets into Separate Excel Files
❤Show your LOVE by “ LIKE COMMENT & SHARE this video ”
❤Don’t forget to “SUBSCRIBE & PRESS THE BELL ICON”
Please support me on
Like us on Facebook –
Website –
Follow us on Twitter –
Follow us Instagram –
Facebook Myself –
YouTube –
▶️WATCH ALL VIDEOS FROM BELOW PLAYLIST :
▶️All Video for MS Excel Magic Trick Series –
▶️Top 10 Excel Video in Hindi –
▶️All Videos of Excel in Hindi –
▶️All Videos of Technology in Hindi –
▶️All Videos of MS Excel VBA in Hindi –
▶️All Videos for Tally.ERP9 GST in Hindi –
#Convert #ExcelSheet #ExcelFiles #MyLiveSupport #ChandanKumarExcel
#mylifesupport #mylovesupport
Most Useful Videos of Our Channel – Must Watch
▶️How to Convert Handwritten Notes in MS Word using Google Drive | Hindi Tutorial
▶️How to Maintain Attendance Register and Salary Sheet in Excel | Step by Step Tutorial in Hindi
▶️Make Fully Automatic GST Invoice | Bill in Excel | Auto Save Each Invoice | Multi Items & GST Rate
▶️🔥How to Recover Unsaved MS Office Files | Excel | Word | PowerPoint without any Software 🔥
▶️Excel में किसी भी Sheet को Print करो Expert की तरह | Become MS Excel Expert
▶️How to Convert any Image to Excel | MS Excel New Feature Tutorial in Hindi
Our aim behind making this channel to make you expert in Microsoft Excel, Microsoft Word, Tally.ERP9, Computer and Technology. You can easily learn Excel, Word, Tally, Internet, Computer in Hindi language. So don’t forget to Subscribe Our Channel.
—————– Chandan Kumar —————–…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Thank you very much Sir for your good explanation . Can we get the name of the Excel files in one ecxel sheet. Is it possible.
Wonderful experiment
It will save a lot of time
Very useful video. Sir Aapke video sub se different hote hey.
Your thinking style is different from others and way of explaining is awesome.
Thanks ….very useful
Mind blowing trick
Ek saath find and replace karne ki liye item alag hai e.g find business name remove karna aur replace blank space chhye
Oooo very nice ticks and tricks and very powerful video
Sir
Mera
Code Mai Syntex error dekha Raha hai
Filename:=FPath & ” ” & ws.Name & ”.xlsx"
How we will get bna code
Useful information
Very good Sir
Ye mai kb se dhundh rha tha
Ab jakr mil hi gya
Jabardast video. Just love your videos too much. Thanks a lot!
Nice
But excel 7 me anaylize tab nhi aa raha
Kese enble kr sakte he??
Can we send all employee performance data of the email body in the form of a picture with its name and performance number
Thanks sir video is more useful for me.. but again 1 by 1 mail can do again everyone…sir pls make a video so that these split XLS files send mail also in 5 to 10 second to everyone…. thanks again for your support..,…
Your videos are very much useful for me
Dear respected sir….
Your videos are very good. I want to talk you about something that is very important. How do i contact you. Thank you very much sir. My number is 9125262316
=====================================
प्रिय आदरणीय महोदय…
आपकी वीडियो बहोत अच्छी होती है। मैं आपसे एक ऐसी चीज के बारे में बात करना चाहता हूं जो बहुत महत्वपूर्ण है। आपसे किस प्रकार संपर्क किया जाए। आपका बहुत धन्यवाद सर मेरा नंबर 9125262316
Sir can you explain the if formula in excel sheet.
Tq sir