Extract Data to Separate Sheets the Right Way!

There’s a little known tool for PivotTables that will automatically extract the source data to separate sheets based on criteria.

0:00 How to extract data to separate sheets in Excel
0:40 Using PivotTables to extract data
4:11 Using FILTER function to extract data
7:23 PivotTables vs Formulas for extracting data

[nathandavis]

You literally just saved me from hours of tedious work. I APPRECIATE YOU! Thank you ma'am!

[esltube]

The last couple of years MS finally woke up in enhancjng the functionality of many of their tools. All of this Power stuff makes data life a lot more fun and easier. Video’s like these are truly valuable. Although I always state nothing can beat assembly language, you just made my day 🎉

[jms]

I manage registration for a youth sports group, and I can pull a master report to figure out who still needs to give us what information or forms, etc. It is constantly-changing data, and it gets split out by division and team so that coaches can be given lists of what their players still need before they can get equipment or participate. You have saved my evenings and I cannot thank you enough for this video!!!

[vijayarjunwadkar]

Great tutorial as usual! Thank you Mynda once again for all the help you offer! Stay blessed!

[therealjeffg]

You are a wizard…..loving all these tips on functionality that most people just wouldn’t find…thank you!!

[wayneedmondson]

Hi Mynda. Another awesome lesson! Thanks for the tips and for always sharing the practice file.. very helpful! Thumbs Up!!

[TheOscarProject]

Exactly filled the need I had. Thank you for the great tutorial!

[Akash-pyyi]

You are a miracle in the world of Magical Excel ❤This was exactly what I was looking for

[amykoszalkahhroofingaccoun]

Just the information I needed exactly when I needed it, thank you!!

[Seftehandle]

it started so simple with control+t and ended up with choosecols(cstack, filter) I loved it!

[simonmassen]

This is excellent, once again just what I was looking for! thank you

[tonyvanriessen]

I have to say that you and excelisfun are the explainers. Thank you.

[sachin.tandon]

Great work Mynda! I wish I was in a job right now, where I could apply all these skills and learnings!

[sacstatesfinest]

This was a game changer! Thank you for the tutorial! You gained a subscriber.

[Fabi_terra]

Hey there! I just wanted to drop a quick message to say thank you for the awesome tutorial. It was super easy to follow along and really helpful.👏👏👏

[ddp]

Thanks the combine method was great and clear to understanding.

[darrylmorgan]

Hi Mynda!Great Tutorial, Loved Both Solutions...Thank You :)

[daimpi]

Thanks for the great video! This was exactly what I was looking for 😊

[HowToAnalyst]

Helpful guidance for a problem I frequently face!

[SGSubra]

Wow, This is an absolute God send. Thank you