I need a little conceptual help on how I should build the following macro:
I have a multi-page report that has up to 3 pivot tables per worksheet. In some cases, the user will want to "export the report for distribution. The following should happen:
A new worksheet created that essentially copies and pastes values and formats from the original report. This is excel 2010 and i would like to preserve pivot table formatting and hidden rows on each sheet. I would also like the pivot charts to be copied as an image. Any idea on how I would go about coding this macro. Even just pseudo-code would be helpful
I have a multi-page report that has up to 3 pivot tables per worksheet. In some cases, the user will want to "export the report for distribution. The following should happen:
A new worksheet created that essentially copies and pastes values and formats from the original report. This is excel 2010 and i would like to preserve pivot table formatting and hidden rows on each sheet. I would also like the pivot charts to be copied as an image. Any idea on how I would go about coding this macro. Even just pseudo-code would be helpful
