Help with beginner question for filtering

[HOUEW]

Need help with possible dynamic formula to filter. Previous user had macro saved to desktop. I want to be able to filter based on results in input 2. I need a "tab" using label for each result from Input 2. So, my result output would be three tabs labeled "A", "D", "F". I have attached excel example as well. Do I have to use dynamic filter or is there another way? Thank you

[jrlindem]

I would list out the values in INPUT 2 as a Text Table and then JOIN that to your other table.  The INNER join results are the ones that you want.  I can mock that up if you need.  -Jay

[HOUEW]

Thank you, Input 2 comes from multiple previous steps to get the selections. So, I can't do a text input each month as they are different results. But thank you!

[jrlindem]

But all of those can culminate into a list that can be used in the same way...

Whether they are in a Text Input list or they come from their own input stream, it's all the same.  If your list is horizontal, you can parse it and then transpose it too.

-Jay

[jrlindem · Accepted solution]

@HOUEW  I've attached a file that has two workflows.  Left side shows how to do this if your data comes in vertically.  The right side shows it coming in horizontally.  If you can adapt your upstream components; the concept shows how you can get there in either scenario.

Hope that helps,  -Jay

[HOUEW]

Thank you! @jrlindem

[binu_acs · Accepted solution]

@HOUEW Dynamic way of doing this with the help of a bath macro