Problem copying Dynamic graphs with Offset formulas (Excel 2013)
I have a workbook with many sheets with the same graphs plotting different date related information – each sheet has in it its own data
In the first worksheet I have set up dynamic graphs (quarterly rolling) with offset formulas using the data on that work sheet. These graphs are all working dynamically
I now wish to copy this worksheet within the same workbook, rename it and have the graphs work dynamically off the data on that worksheet.
Every time I copy the worksheet and rename it I lose the dynamic function
I would appreciate any assistance regarding the copying of Dynamic graphs with Offset formulas
Thanks
Fred