INPUT |
<tbody>
</tbody>
Fixture | HS | AS |
TEAM A v TEAM B | 1 | 1 |
TEAM C v TEAM D | 2 | 1 |
TEAM E v TEAM F | 1 | 2 |
TEAM A v TEAM C | 3 | 0 |
<tbody>
</tbody>
Im looking to try and write a macro to autofilter a table based on the contents on the cell above. This cell is on a different sheet to the table I am looking to filter.
Ideally the I would like to return the following:
TEAM A |
<tbody>
</tbody>
Fixtures | HS | AS |
TEAM A v TEAM B | 1 | 1 |
TEAM A v TEAM C | 3 | 0 |
<tbody>
</tbody>
My range is alot larger using 365R x 225C
Any help with this would be massively appreciated as I am very new to macros.
Thanks