Split Excel Worksheet into Separate Worksheets Based on Column Value WITHOUT VBA MACRO

In this Microsoft Excel video tutorial I demonstrate how to split a worksheet into separate worksheets based on column value. For each change in column value a new worksheet is created. Without using a VBA macro, one of the quickest ways of achieving this is with a PivotTable.

#microsoftexcel

[vickyvalle]

This is a GREAT tip! If I could like this 30 times, I would!

[agencycomp]

I have spent hours trying to find a VBA function for this process. Brilliant!

[WealthTastic]

Fantastic to the point explanation. Searched so many videos for this. Thanks a lot

[MichelleBretschneider]

This was amazing and will streamline a lot of my work. Very easy to follow explanation, thanks very much!

[wassouf]

Life saver, thanks for sharing this! Can't like this video enough!!

[jkParsonsK]

"...hopefully that's useful..." Yes. Yes it is. I spent waaaay too much time trying to figure out how to do this w/ VBA, etc. And this does it in less than a minute. Thank you!

[jmart]

I use excel daily. Never knew about this feature. Very useful. Thank you

[miriamebere]

So straight to the point and easy to understand. Thanks so much sir

[martingregson]

Outstanding very easy and simple to follow method, thank you

[KristyCochrane]

This helped me so much! Easily executed on my spreadsheet - thank you!

[melissajones]

elegant, easy, and DOI why didn't I think of that!

[CarletonRecruitment]

How to update data in a main sheet so it's changes in all others?

[SheriBrothers-vz]

Question: If I add a new line to the main spreadsheet, will it automatically show up on the corresponding additional tab that matches the account type?

[JulieReed-ji]

if you change information on the first sheet does it change on the other sheets?

[colleenforrest]

Will this work for data that is in multiple tabs?

[sridatta]

Sir please explain split sheets in one shot is it possible sir using pivot table

[Kuhan-kf]

SIR CAN WE ABLE TO REMOVE FILTER ICON FROM THE SPREAD SHEETS

[mhla]

Ha so much easy compared to another annoying methods.