This is my first post, I have a bit of an automation problem;

I have 10 charts already made from chemical and statistical data.

Each of those charts has 6 data series plotted in them. I need to duplicate those 10 charts into new worksheets 21 times (or until row 1 contains no data), incrementing the "series Y values" for the plotted data by one column for each. For example, the first chart has data called from B6, the second from C6, and so on.

Each new worksheet will be named by the contents of row 1 to match the cell that is incremented.

Any insight into this problem would be extremely appreciated. I'm not a very capable programmer but I realize this is definitely better tackled by a macro than brute force.

Thanks in advance!