Hello All,

I have a workbook with sheet 1 containing data, and sheet 2 containing
charts based on the data in sheet 1. I want to be able to use these two
sheets as templates for new sheets in the same workbook like so:

sheet 1 data ------- sheet 2 chart

sheet 3 data ------- sheet 4 chart

sheet 5 data ------- sheet 6 chart

etc.

When I try to copy sheet 1 to sheet 3 all is well, but when I copy the
charts in sheet 2 to sheet 4, those charts source data is still gathered
from sheet 1.

I need a method to replace the "sheet reference" in the source data to refer
to the PREVIOUS sheet, not the original sheet.

Hope that makes sense. I have looked everywhere in help as well as the MS
site, and google-a-go-go with no luck.

If you can help it would be greatly appreciated.

JMA