One of my favourite sources for blog posts are questions I get asked by customers. And this one falls into this category. It was from an Excel newbie and what he needed to do was extract the results for a specific customer and then email them a copy of those results only. First of all, I know this can be done faster and be more automated but I believe that for an Excel newbie – this is more doable.
Here is the file (downloaded from Kaggle.com)
So what we want to do is:
- Filter out the results for a specific Brand and Main ingredient.
- Copy and paste those results into a new file
- Save the file
- Return to the original file and reset the filter – so you can do it for another one.
This is how you do it.