guatelize
08-21-2008, 06:04 AM
Dear
I don't have very much experience in macro writing, but I tried to assemble a macro from different examples, but it didn't work at all.
I hope you can help me to find a solution.
I have pivot table starting A9, ending in Q9. Behind the Pivot table, I created extra columns, R to V, with formulas. I created also conditional formatting to fill Subtotals and Grand Totals with color automatically.
Every time the Pivot Table is changed, the formulas in columns R to U are fill down until the end of the data of the Pivot Table, from the condition in column E. When only one filed ("Rep")in the Pivot Table is selected, the formats are not deleted, I have to remove it every time manualy to print a proper and presentable report. Is it possible to automate this with a macro ?
(I hope my explanation is understantable, my English is not so good)
Thank you very much for your help.
Olivier
I don't have very much experience in macro writing, but I tried to assemble a macro from different examples, but it didn't work at all.
I hope you can help me to find a solution.
I have pivot table starting A9, ending in Q9. Behind the Pivot table, I created extra columns, R to V, with formulas. I created also conditional formatting to fill Subtotals and Grand Totals with color automatically.
Every time the Pivot Table is changed, the formulas in columns R to U are fill down until the end of the data of the Pivot Table, from the condition in column E. When only one filed ("Rep")in the Pivot Table is selected, the formats are not deleted, I have to remove it every time manualy to print a proper and presentable report. Is it possible to automate this with a macro ?
(I hope my explanation is understantable, my English is not so good)
Thank you very much for your help.
Olivier