All,

I have a drop down box that allows the user to select from a list of
worksheets in the workbook. The selection returns a value equal to the
name of the worksheet. There are multiple worksheets with data sets.
Each data set is identical i.e. two columns in A, and B. The lengths
of these data sets could vary.

I have an x y scatter graph in a summary worksheet. How do I use the
dropdown box to select which data (worksheet) is plotted in the x y
scatter graph?

Thanks in advance for all your help,

Regards

Joseph Crabtree