Push a dataRange from active workbook into a closed workbook

[Mr.Karr]

Is there a way to filter columnA and copy data into a file.xlsx located in a closed folder ?

Select	Team	Game	Score
Yes	A	Cricket	98​
Yes	D	Cricket	92​
Yes	C	Cricket	91​
Yes	W	Football	88​
Yes	J	Football	100​

Activeworkbook path: C:\Users\excelUser\Documents\dataFile.xlsm

To file folder path: C:\Users\excelUser\Documents\summary.xlsx

Sample file.xlsm attached for your reference.

Much appreciated.

 

[Marc L]

Is there a way to filter columnA and copy data into a file.xlsx located in a closed folder ?

What is the true meaning of « a closed folder » ?‼​

​