Macro to add to Name Manager and Create Charts

Hi again,

Ok, I think we're heading in the right direction!

The situation becomes a lot more manageable when you use worksheet-level defined names rather than workbook-level defined names.

The attached workbook contains six individual worksheets (each with its own set of graphs) and a Master Template worksheet on which you can perform a normal Worksheet Copy operation as many times as are required - no macros are required.

I used some macros for formatting and customising the graphs - these are no longer required. I've left them in the workbook just in case you'd like to take a look at them, but as I said, you don't need to use them.

Hope this helps - please let me know how you get on.

Regards,

Greg M