Split Data Into Multiple WORKBOOKS Based On Column value

Split one excel sheet into multiple sheets based on column value-Goto the below link:

Please visit our website for a selection of valuable templates.

Connect with us on our social media platforms:

Earlier we have split our data into separate excel sheet but this time, we will split spreadsheet records into a new workbook. It’s useful and reduces our effort in making different workbooks with the same data.

It will take hardly 1 min to complete the task. Isn’t that interesting?

Note: Please note that before you run the code please check that there is no other file with the same name. For example, if you run the code for the second time it will give you the following error as the same file already exists in your location.

Download File:

[TanvirAhmed]

Incredible. It works flawlessly. Thank you so much.

[eddynoboa]

When I create the button macro, I right click it then assign a macro, in my case I do not see the list that you have in order for me to click "SplitDataByCoumn". How do you do that button so when I create a macro I have the chance to see the "SplitDataByColumn" the way you have on this video.

[soothing_music]

Thank you… however when i start running the macro .. it is asking everytime to save the file for each iteration? What could be done in this casw

[horrellbt]

This is great work.
How could I limit what is copied over to just one column of the table?
For example, I would want to bring just column C over in the newly created workbooks

[Kesselnusse]

Hello, your solution is fantastic and precisely what I needed. I do have a question, though, regarding the Excel file's size. While it works exceptionally well for smaller files, for larger ones (ex: 900K rows), it only retrieves the header and saves the file empty. Could you please assist with this issue?

[Jheinsmith]

Thank you a lot sir, you are a genious 💡

[traceyansell]

Hello - How can the code be updated so that the new workbook file name is the value that you are splitting the files by? Instead of just workbook(#)

[Kaify]

Thanks dear.. very helpful. Pls tell how to change the path to save the spiltted workbooks.

[cindyqueen]

Thank you for this! Question, is there a way to add something to the code that will provide an extra piece of information to the title/name of each workbook? For example, if I’m choosing a column that contains a person’s name, that appears as the name of the book but what if I wanted to add another column from the book that contains say the name of a store so the book would be named person’s name and name of store is that possible? Would you be able to helm me with that please ? Thank you

[jannuasheeshmunkumar]

How to make individual sheets through this? I tried but developer options are disabled for this.

[navaidmansoor]

Hi.. Need help. This macro is exactly what I am looking for. I copied and assigned it to my file. it goes thru all the steps as per the video without any errors, however the seperate files created are the entire data set and not filtered. Works like a charm on the downloaded file but not on my file. can u help

[gaybarile]

Hello. Thank you for this. However, it seems the file is inaccessible. Could you kindly check the link? Thank you again and have a nice day!

[flacobit]

Its working pretty nice.I need to add filter to created files. How could I make this?

[eddynoboa]

I clicked on your download file and is empty?