Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I work on QV9, i would like to know how can i export a part of a pivot table?
For example, i have the following pivot table :
A | B | date1 | date2 | date3 |
---|---|---|---|---|
xxxx | tttt | uuuu | iii | ddd |
yyyy | tttt | uuuu | iii | ddd |
zzzz | tttt | uuuu | iii | ddd |
I would export to excel this table :
A | date1 | date2 | date3 |
---|---|---|---|
xxxx | uuuu | iii | ddd |
yyyy | uuuu | iii | ddd |
zzzz | uuuu | iii | ddd |
(the same pivot table than the up but without the second column)
the B column is needed in "presentation" (user interface) but not in the export that why i want to supress it from the export
Thanks
It can be done with a macro. Create a button, attach macro to it. Two options:
1. Use a macro that copies your table, and deletes 2nd coulmn. Requires system access.
2. Create a copy of ypur table which doesn't have column B. Keep it on a hidden sheet. Macro only need to send this hidden table to excel. This is much simpler, no need for system access.
Regards,
Michael
It can be done with a macro. Create a button, attach macro to it. Two options:
1. Use a macro that copies your table, and deletes 2nd coulmn. Requires system access.
2. Create a copy of ypur table which doesn't have column B. Keep it on a hidden sheet. Macro only need to send this hidden table to excel. This is much simpler, no need for system access.
Regards,
Michael
Create hidden pivot without 'B' for export purposes.
Thank you!
I 've used the first option (macro)
it's work perfectly
Regards,
Amine