Hi
I want to put a validation on a cell which will contain a list of months.
When the user selects a month from the list I want to automaticallyl filter
the data on a worksheet and create a chart from the filtered data.

The code is written and the validation is in a list on the cell.

How do I get the information selected from the list into the function so I
can filter the worksheet??

Any ideas gratefully received.