Macro/VBA to allow Filter based on cell value from different Tab

[Jzfbkr]

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]INPUT[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Fixture[/TD]
[TD]HS[/TD]
[TD]AS[/TD]
[/TR]
[TR]
[TD]TEAM A v TEAM B
[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]TEAM C v TEAM D[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]TEAM E v TEAM F[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]TEAM A v TEAM C[/TD]
[TD]3[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]


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:

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]TEAM A[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Fixtures[/TD]
[TD]HS[/TD]
[TD]AS[/TD]
[/TR]
[TR]
[TD]TEAM A v TEAM B[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]TEAM A v TEAM C[/TD]
[TD]3[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]


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

 

[livernut]

Hi I am new to the forum and like this thread.
However I am easily confused and new to macros and forums.
If I have data on one sheet which I would like to filter using a cell on a query sheet, and then to copy the data to a third sheet and rename using the filter selection.
Can someone help?