Chart plotting using dropdown list pulling data from different sheets

**tolu** · 01-14-2013, 05:06 PM

Hello,
Thank God for this forum! I am new to writing macros and need help. I am currently working on a statistical analysis and I would like to have a chart with a drop down list. When I drop down the list and pick a number, i would like the chart to to plot series of data from the different sheets corresponding to the dropdown list number - a plot of count dates vs count 1 and count 2. I have tried couple of codes I saw on you tube and other forum and it didn't work. Couple of examples I saw in the forum described when all the data are in the same sheet with the chart.
Please see the attached sheet
Your help will be appreciated

counts.xlsm

Thanks

T

**oeldere** · 01-14-2013, 05:15 PM

If all the sheets have the same (header) format, then you can use an macro to put them in a summary sheet.

After that you will be able to filter / count / etc with the data.

So are all column equal ?

**hilljm** · 01-14-2013, 10:41 PM

Do you have the code to put all of the data into a summary sheet? I am trying to do a similar task but have limited VB knowledge and would like to summarize a large number of sheets into one master sheet detailing which sheet each record came from.

**tolu** · 01-14-2013, 11:00 PM

All the columns are similar and the header the same in each of the sheet. I have seen where the data are plotted from the individual sheet when the dropdown list is used without the summary sheet.I need help to do this.
Thanks
T