paste formats to all worksheets
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
|