S
Singh
Subsequent to using the 'show pages' function on a pivot table, I have a
workbook with multiple worksheets of pivots.
I would like to paste-special values on all worksheets so they can no longer
be manipulated by the pivot. Then copy a pre-defined format to all
worksheets.
Bonus question: Would it be possible to systematically add data validation
dropdowns to the first two columns of each of these newly created worksheets?
Any help would be greatly appreciated.
Thanks,
Singh
workbook with multiple worksheets of pivots.
I would like to paste-special values on all worksheets so they can no longer
be manipulated by the pivot. Then copy a pre-defined format to all
worksheets.
Bonus question: Would it be possible to systematically add data validation
dropdowns to the first two columns of each of these newly created worksheets?
Any help would be greatly appreciated.
Thanks,
Singh