im sorry, the results in my first solution do not match your example results, it only gives you filtered rows
to get your example results, do this instead....
delete all of the data from inside the tables of sheet 111 and 222 (keep the header row)
now, on sheet 111...
in cell B3, enter this formula:
in cell H3, enter this formula (then drag it down):
in cell I3, enter this formula:
next, on sheet 222....
in cell B3, enter this formula:
in cell H3, enter this formula (then drag it down):
in cell I3, enter this formula:
Bookmarks