March 17, 2020
I was wondering if it were possible to add a button in my dashboard to allow users to export data as they prefer.
I want let them download the only filtered data from Excel to csv file
I've attached a file as example to explain what I mean.
the DB is hidden to users. The dashboard is *.xlsb format (no macro).
July 16, 2010
I'm not sure I understand what you mean, but did you know that if your user double clicks on a value cell, Excel will create a new worksheet containing a table of the underlying rows that make up that value. From there your user can copy the table to another file.
If you want to automate this further, you will need a macro/VBA.