Hi there,
I have searched through this forum cannot find a solution to what I need so
here goes (or perhaps I have missed it).

I have a workbook containing 11 worksheets - one for each country with the
first worksheet containing a set of standard charts which are reused for each
country. I am currently manually amending the data range and selecting the
worksheet and highlighting the data for each country (so have to do this 10
times). The data is in the same location on each country worksheet so really
the only amendment is the worksheet name.

How do you recommend that I speed up this process. I use a pivot chart for
another report and find brill for this type of thing as I just click the
country from the drop down box) and wonder if I could set up this type of
principal for my workbook.

Hope all this makes sense.

Rgds, Teddy