Split one excel sheet into multiple sheets based on column value

Please visit our website for a selection of valuable templates.

Split Data Into Multiple WORKBOOKS Based On Column Goto the below link:

Updated Weekly/Monthly Calendar for MS Excel

Supposing you have a worksheet with huge rows of data, and now, you need to split the data into multiple worksheets based on the Name column and the names are entered randomly. Maybe you can sort them first, and then copy and paste them one by one into other new worksheets. But this will need your patience to copy and paste repeatedly. Today, I will talk about some quick tricks to solve this task. To know the ways of doing this job effectively let’s watch the video.

The above macro splits data into multiple worksheets based on the variables on a column found in Excel.

An InputBox asks you about "Header Names" then which columns you'd like to filter by, and it just creates these worksheets.

Download the file:

#excel #exceltips #exceltricks

[TheMKTube]

Thanks for showing us you know how to do it 👏
Edit: For people who came to learn: I ended up creating a pivot table for the column I want to use to split into sheets. When you double-click the value of each category in the pivot, it actually launches a new Sheet with exactly the data that you need. No VBA required. Btw this approach won’t copy over hidden columns. Hope that helps!

[raniafun]

This guy is made video only for himself not for others.

[nickmuckler]

This is exactly why they need to show us how many downvotes a video has

[sushantnarvekar]

How to create that button. You missed that part

[quachanhvang]

You reallly save my life bro! God bless you!

[readingworld]

Thank you very much sir . it's really a wonderful video

[craiglong]

Thank you. I am going to try to implement in an existing template in the next day or so.

Question: I noticed that the formatting did not come across on the new tabs. Is it possible to move the existing table design along with formatting into the new tabs? Does this macro facilitate this? Looking to integrate into a macro that I have been working on.

Appreciate any reply in advance. Regards.

[davidpraveen]

Your work was excellent.... saved a lot of time... exactly what I was searching for....awesome

[madhujayaraman]

This is brilliant!!! This saved me 6hrs of work. I finished the report in 10 mins. Bro you are my lifesaver!!!

[thidnascimento]

Fantastic! Thank you so much! i had 11, 000 rows with 81 values, 81 worksheets turn easy with your macro, thank you

[eddynoboa]

when you say "click at this button here (00:58)", I dont see that button on my end

[yosephmatalo]

Brother, Thanks for sharing but aren't gonna show us how you did it?

[suryakanttikare]

Thanks a lot. Yours macro enabled file helped me to save lot of time. Can you please make a video how to create such macro enabled file. Thanks again.

[TheUKelvin]

That's really awesome! Can you also share if we can export all the sheets in one workbook into different files?

[brandedadnan]

Thank you. it is so simple and very creative. Saved lots of time. can you include how the total sheets can be sent to create different workbooks.

[mrbdent]

What is the "click on this button"? Excel does not come with this button

[varishadar]

Will it also work if for some columns we have some blank cells?

[marclink]

Exactly what I am looking for ! I have around 120 files with over 1, 500 rows in each. I was able to combine them in a single excel sheet (around 150k rows), with file name in first column. However, following your steps I am not able to split them into individual sheets. Instead, excel creates a new sheet with only the headers. Could you help me or is my data simply too big?

[pritishsrivastav]

Nothing happens when I select the rows and columns. No new sheets, no error messages. Please tell me if there are any limitations, I've already reduced the column values to 30 characters.

[akashkumar-pryi]

Go to his description he has given a downlode link of the excel file