How to export just a part of a pivot table columns to Excel

[#1]

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

[Anonymous · Accepted solution]

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

[whiteline]

Create hidden pivot without 'B' for export purposes.

[#4]

Thank you!

I 've used the first option (macro)

it's work perfectly

Regards,

Amine