Hi guys,

maybe somebody can give me a hand, i have at work a workbook called "work.xlsm" this file have 12 rows with over 200000 records.
I'm creating a dashboard in file called "dashboard.xlsm" when i open this file i would like to run automatically advanced filter and copy data from "work.xlsm", because the file is very heavy and the pc's are slow maybe it's possible to do without opening and closing the "work.xlsm" file?

All ideas are appreciated guys i need to do this in some efficient way because now i'm spending about 25min just to open, copy and pasting the data.

Thanks