VBA creating auto chart

Hi Guys,

My requirement is pretty hard. Can somebody help me on this ?

I have a workbook which contains a master worksheet and 12 datasheets which contains the raw data.

in the Master sheet i kept a dropdown list which has the 12 worksheets name , so when ever i'm choosing a value in the dropdownlist it should auto populate a Chart in the master sheet with the data table in the respective worksheet.

I'm not sure this can be done ? is this possible ??

Thanks,
Safi.

Hi Guys,

Can anyone help me out?

Thanks,
Safi.