Hello everyone. I am new to this forum. I am having a Pivot table and i want to drill down to base data. My requirements are:
1) The Drill down data should appear in a pre-named Sheet in same work book. Each time when i double click the Pivot values, the supporting data should come and sit in this pre-named sheet. But each time it should overwrite the existing data.
2) I want only a pre-defined columns to appear in the drill down sheet. Not all columns from the base sheet.
Can anyone help me in solving this?
Thanks
Nisha
1) The Drill down data should appear in a pre-named Sheet in same work book. Each time when i double click the Pivot values, the supporting data should come and sit in this pre-named sheet. But each time it should overwrite the existing data.
2) I want only a pre-defined columns to appear in the drill down sheet. Not all columns from the base sheet.
Can anyone help me in solving this?
Thanks
Nisha