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.
Bookmarks