Return an entire row based upon one cell result in each row

Hi all,

This one is hard for me but would be basic for the experts here. No macros please.

I've set this up so that column AB has a number corresponding (from a Vlookup) to each month 1-12 for "Jan"-"Dec" and a 0 for "None"

I'm looking for a formula in the January tab to output the results oof the row from AC through to BB in each of the different tabs for the corresponding months.
The end result being for instance anything with a 1 for column AB in "Master" will be in the January tab.

Thank you so much in advance. File attached.

The answer is dependent of your Excel version that you didn't inform, in this case is for Excel 365.
As the formula shows you don't need column AB (or the table in BD:BE) with month number since you can extract it from the original column 'O'.

Formula:

Please Login or Register  to view this content.

Just in case a formula for column AB would be:

Formula:

Please Login or Register  to view this content.

Thank you very much. It is Excel 365.

My fault but i did not specify how i wanted it to work further. There will be approximately 500 entries in the "Master" sheet and this data will continually be updated. When i pasted in my entire data (approximately 500 rows) I need each months tab to populate the number of rows corresponding to that month.

So for instance January might have 70 entries populate in it's tab.

That was my bad not being clear.

If you could help get it to this stage that would be great. Thanks so much.

How about

Formula:

Please Login or Register  to view this content.

which will spill down & across for as many rows as needed.

Besides the correction the file also have a Power Query alternative solution.

Hi guys,

Just want to say a big thank you to both of you. We now have lift off and it's working swimmingly.

Legends!

Glad to help & thanks for the feedback.

Glad to help & thanks for the feedback, also.