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
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
Hi Mynda,
thanks for your reply. I protected the workbook.
I was looking for a feature to enable users to export / save data as a file
I attach a picture to explain.
thanks
Mark
