About this tutorial:
Video duration: 13:59
Learn how to break data in to multiple Excel files in this tutorial using Excel VBA & Advanced Filters
Break Data in to Multiple Excel Files – How to Video
Post Author: OfficeTutes.com
Related Posts
23 JUL
SAPLookup – an Excel formula for reading SAP data
About this tutorial: Video duration: 3:6 SAPLookup will transform any company using SAP by letting users access information from...
22 JUL
Como Baixar Instalar e Ativar Pacote Microsoft Office 2016 em PT-BR ( COMPLETO )
About this tutorial: Video duration: 4:52 ✖️ Fala ai Galerinha Tudo Beleza? ✖️ KF Tutors na area para mais um Video aqui...
22 JUL
Windows 10 – How To View/Show Hidden Files, Folders and Drives
About this tutorial: Video duration: 26 Windows 10 - How To View/Show Hidden Files, Folders and Drives in Windows 10. Follow...
22 JUL
Excel 2016 formulas and functions pashto tutorial Awesome Tips and Trick – Part 23
About this tutorial: Video duration: 13:12 string & text functions math & trigonometry functions database functions statistic...
23 thoughts on “Break Data in to Multiple Excel Files – How to Video”
Anchal Gupta
(June 30, 2018 - 3:23 pm)Hi, This is a great video. I was looking for this splitting content. I found you used Extract range to copy the filtered data and then saved, however, if I don't want that rather copy within same cells and save. How would the code change? can you please help? Thanks.
pradeep singh
(June 30, 2018 - 3:23 pm)Thanks worked like charm on my file having 700,000 rows branches 104 and file over 50 MB.
pradeep singh
(June 30, 2018 - 3:23 pm)can you share the script
Daniela Valdevenito
(June 30, 2018 - 3:23 pm)Hello, how can I save the file with more than one criteria?
Paras Goel
(June 30, 2018 - 3:23 pm)You sir, are a magical genius! Thank you for gracing us with your presence!
RAKESH SHARMA
(June 30, 2018 - 3:23 pm)Hi can you help me I want if value is anywhere in sheet1 and when I put the same value in sheet2 any cell I get that value in front of that….
Richard Masilang
(June 30, 2018 - 3:23 pm)Good day, can you help me in how to break data from different category in a list
Camill Corsinie
(June 30, 2018 - 3:23 pm)I am trying to use specific columns so as to create new worksheets.
Anubhav Gupta
(June 30, 2018 - 3:23 pm)Very good dear.. i am really so much happy..
can you help me with one more thing with? you have filtered the data at Salesman level but if i want with Salesman and Month level data then how will be done?
Regards,
Anubhav
Mahmoud Hamed
(June 30, 2018 - 3:23 pm)Thanks for this helpful video
but If I need to delete the salesman column in the extracted file and also the header row, how can I do it.
if you can help me in this issue it be great.
thanks again.
Joris Vanderlinden
(June 30, 2018 - 3:23 pm)Great how-to! Thanks a lot!
Karalapati Preethi
(June 30, 2018 - 3:23 pm)hi,
nice video. can i send the joseph excel sheet to joseph folder which is in another location
Harry Cummins
(June 30, 2018 - 3:23 pm)Perfect for our needs. Thank you for sharing!
jay kamdar
(June 30, 2018 - 3:23 pm)Thanks for sharing the video. While I was trying to break data into Multiple txt files, this video was very helpful. I just changed the following code-
the ActiveWorkbook.SaveAs Filename:=curPath & cell.Value & ".txt", _
It did convert my files to txt. However, when I open it…The words are not Emglish like..they seems to be some characters or encryption looking of some kind.
Your help is greatly appreciated.
Joan Black
(June 30, 2018 - 3:23 pm)Awesome of you to share. Worked like a charm the first time. Thank you very much.
curlyfrogoddess
(June 30, 2018 - 3:23 pm)awesome video! But how do you extract it?
Ludvig Borga
(June 30, 2018 - 3:23 pm)Fantastic Video. This really helped me solve a problem I was having at office with extracting data from a central database. I will definitely be visiting your website for more tips and tricks. Cheers!
Eric Soetrisno
(June 30, 2018 - 3:23 pm)hi, how can I add the "extract" button shown in the file? I've finished setting up the formula but cannot complete doing the refresh. Could you please let me know how? Thank you.
Ravi Surolia
(June 30, 2018 - 3:23 pm)this is amazing , I was searching from long and today I got it, you having really amazing expertise sir….
brians6460
(June 30, 2018 - 3:23 pm)Hi, this is excellent. Can you show how to break into multiple tabs on the same workbook?
Dawn H
(June 30, 2018 - 3:23 pm)This is super helpful. One question I have. Is there way to add report titles to the top of the report?
Brett Bingham
(June 30, 2018 - 3:23 pm)Can you attache the module code?
Driss HAFFAD
(June 30, 2018 - 3:23 pm)EXCELlent 😀