asked on September 24, 2020
Hello,
Can we do something like this:
Assuming I have a table. I want to use one of the columns (colA) as a filter in the following way: For every value in this column, to save a sheet in Excel with this value is the sheet's name, and the content is the other table's data filtered by this value in that colA.
And all is saved into a single Excel file.
Hope I managed to explain what I need 🙂
Is it supported?
Thanks!
Moshe
⋅ September 25, 2020
Hello, Moshe,
Thank you for posting to our forum.
We would like to inform you that our export functionality provides the following logic: all pivot table content that the user sees is exported.
Accordingly, we suggest 2 workarounds for your case:
Please note that each sheet will be exported to a separate Excel file. For now, Flexmonster does not support exporting multiple sheets to one file.
Please let us know whether the recommended approaches work for you. If they do, please contact us for further details and examples on this matter.
Best regards,
Milena
⋅ October 9, 2020
Hi, Moshe,
We were wondering if our response helped you with your question.
Do our suggestions for exporting to Excel work for your case?
Looking forward to your response.
Best regards,
Milena
⋅ October 20, 2020
Hello, Moshe,
Hope you are doing well!
Our team would like to kindly take an interest in whether you had a chance to check our response.
Did the suggested workarounds help you with your question?
Waiting for your reply.
Kind regards,
Milena
