Dear all,

I have a sheet with some dynamics charts, and when use "move or copy"
to copy the sheet, all the chart formula changed to fix series
numbers.

Is there anyway to copy sheet in which dynamic charts keep it dynamic
formula?

In case you didnt know, I use "local define name" in the chart fomula.

Thanks all.