Hi,

Thanks is advance for any advice.

I have two sheets, Portfolio and Prospect Chart (this is just a chart).

In portfolio, I can add from A1 to A### the stock symbols I want to evaluate. When I run my macros, it generates a new tab for each stock symbol and downloads the data from yahoo.

What I am missing is how to be able to toggle in my Prospect Chart through all of the different stock sheets - I would hope I could have a dropdown list that references Portfolio A1 to A###, or radio buttons that are based on that list. I have the code to update the data source of the chart, but it requires a dialog box that acts as a "find and replace" - instead, I am hoping to be able to modify that code so that it already knows what I want to find and replace based on my dropdown or radio button selection. The key thing, is that the drop down list or radio button has to be dynamic - I may be reviewing 25 stocks today, and maybe 30 tomorrow.

I would imagine this route will make what is already a heavy file even bigger, so if you have simpler alternatives but that still allows for "toggling" from the chart sheet, that would be great.

Thanks,
Chris