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!!
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!!