All,
SUMMARY
Can only the data be copied from each tab that is linked to a pivot Table? I need to send each department a report. And I do not want then to be able to click in the Filters section to see other departments data.
DETAILS
I was able to use the Pivot Table Tools > Analyze > Options > Show Report Filter Pages functionality to generate separate tabs/ worksheets for each department. And found VBA on the web that then copies each tab /worksheet and creates a separate workbook for each. So far, so good.
ISSUE = each department's individual worksheet still has the underlying data "attached" to it. So the department could click in the filter and select other departments data.
Thanks,
Bob
SUMMARY
Can only the data be copied from each tab that is linked to a pivot Table? I need to send each department a report. And I do not want then to be able to click in the Filters section to see other departments data.
DETAILS
I was able to use the Pivot Table Tools > Analyze > Options > Show Report Filter Pages functionality to generate separate tabs/ worksheets for each department. And found VBA on the web that then copies each tab /worksheet and creates a separate workbook for each. So far, so good.
ISSUE = each department's individual worksheet still has the underlying data "attached" to it. So the department could click in the filter and select other departments data.
Thanks,
Bob