MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Table Question


Posted by Barry on August 31, 2001 8:44 AM

I have a pivot table that summarises costs by month by cost centre.

When I double click a value to drill down to the detail is there any way to automatically format the resulting sheet to customised column widths, row heights etc rather than the default values.

Any help gratefully received !!


Posted by Mark W. on September 01, 2001 1:31 PM

Record a macro.

Posted by Barry on September 03, 2001 12:19 AM

Posted by Barry on September 03, 2001 12:21 AM

Thanks Mark,

Is there any way to automatically run that macro as soon as the cell is double clicked ?

Posted by Mark W. on September 04, 2001 7:26 AM

There may be an event/trigger in VBA to support
this. You'll need to check with someone far more
proficient with VBA than me.