Filter and copy Table from one workbook to another

[kabootar]

Hi All,

I am struggling with copying over a filtered table from one workbook to another. the workbooks are both open.

The table is in the commission tab in the Sales Master - 2018.xlsm file

So, I need to filter the table to show all the data of the name of the person at the end of the filename, the filename is: "Sales File - Billy.xlsm"
Then copy this filtered table into the commission tab in Billy's sales file

The filepath for the master file is in a named cell in the data tab in Billy's file.

I have tried to code this in different ways but to no avail.

Hope this makes sense.

Thank You!!