Copying changed pivot report headings
Currently I create 6 reports in one workbook using basically the same data
except the layout will be re-arranged as per the group viewing each report. Each month, I change a number of columns headings to reflect the current reporting month... and I need to go into each of the 6 reports and repeat this (the same heading change over and over). Is there a way that if I change the heading on the first report it will auto change in the subsequent reports. I can't copy and paste as you can't change the pivot report structure. Thanks, Mary-Lou |
Copying changed pivot report headings
Mary Lou - Assuming:
- the columns headings are not part of the pivot report - the column headings are in the same cells in ALL 6 workbooks Then you can select all of the workbook tabs (CTRL+click each one) and type in the changes in 1 workbook...the changes will appear in the same cells of each workbook you've selected. "MLK" wrote: Currently I create 6 reports in one workbook using basically the same data except the layout will be re-arranged as per the group viewing each report. Each month, I change a number of columns headings to reflect the current reporting month... and I need to go into each of the 6 reports and repeat this (the same heading change over and over). Is there a way that if I change the heading on the first report it will auto change in the subsequent reports. I can't copy and paste as you can't change the pivot report structure. Thanks, Mary-Lou |
Copying changed pivot report headings
Unfortunately the headings I have the issue with are part of the pivot table.
I can easily handle any headings I also do outside the pivot reports as I have a "base" headings tab that stores the redundant data that changes month after month and I simple point all the reports to this "base" tab. However I would like to do something similar (probably not possible) to actual pivot report headings. "Chris" wrote: Mary Lou - Assuming: - the columns headings are not part of the pivot report - the column headings are in the same cells in ALL 6 workbooks Then you can select all of the workbook tabs (CTRL+click each one) and type in the changes in 1 workbook...the changes will appear in the same cells of each workbook you've selected. "MLK" wrote: Currently I create 6 reports in one workbook using basically the same data except the layout will be re-arranged as per the group viewing each report. Each month, I change a number of columns headings to reflect the current reporting month... and I need to go into each of the 6 reports and repeat this (the same heading change over and over). Is there a way that if I change the heading on the first report it will auto change in the subsequent reports. I can't copy and paste as you can't change the pivot report structure. Thanks, Mary-Lou |
All times are GMT +1. The time now is 07:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com