

March 17, 2020

Hello everybody
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).
Thanks
Mark


July 16, 2010

Hi Mark,
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.
Mynda
1 Guest(s)
