Hello,
I am trying to resolve a sorting issue. I've looked through the forums and used google search but could not find an answer to my inquiry.
In essence, I want to be able to have a drop-down menu on one sheet that will allow me to choose and retrieve data (charts) from many other worksheets. So, if, for example, I chose product RCY_EY56 under my drop-down menu, Excel would pull up the corresponding sheet and chart. It would be nice if the pulled up sheet resulted in only the chart (sized appropriately) being shown (and not everything else that's on the sheet) but one step at a time, right?
Currently, I have about 50 worksheet tabs with different products and corresponding data listed on each. Each tab is an individual product. I created a pivot table and a pivot chart for each corresponding product on a new tab. So I have 50 tabs filled with a pivot table and a pivot chart (which I want to be able to pull up on that one drop-down menu). I want the drop-down menu to sort through and pull up the corresponding product's pivot chart when I ask it to.
I've considered using Options Buttons to sort through the information, but I imagine that would be quite tedious and time-consuming for 50 products. I'd appreciate any feedback, hints, or information regarding how else I might be able to use a drop-down menu to sort through the sheets and pull up the relevant product (e.g. selecting RCY_EY56 under the drop-down menu should pull-up RCY-EY56's corresponding pivot chart.)
I cannot upload the data due to privacy concerns, so please ask if you want me to elaborate on my question.
Thank you for your time.
-Door
I am trying to resolve a sorting issue. I've looked through the forums and used google search but could not find an answer to my inquiry.
In essence, I want to be able to have a drop-down menu on one sheet that will allow me to choose and retrieve data (charts) from many other worksheets. So, if, for example, I chose product RCY_EY56 under my drop-down menu, Excel would pull up the corresponding sheet and chart. It would be nice if the pulled up sheet resulted in only the chart (sized appropriately) being shown (and not everything else that's on the sheet) but one step at a time, right?
Currently, I have about 50 worksheet tabs with different products and corresponding data listed on each. Each tab is an individual product. I created a pivot table and a pivot chart for each corresponding product on a new tab. So I have 50 tabs filled with a pivot table and a pivot chart (which I want to be able to pull up on that one drop-down menu). I want the drop-down menu to sort through and pull up the corresponding product's pivot chart when I ask it to.
I've considered using Options Buttons to sort through the information, but I imagine that would be quite tedious and time-consuming for 50 products. I'd appreciate any feedback, hints, or information regarding how else I might be able to use a drop-down menu to sort through the sheets and pull up the relevant product (e.g. selecting RCY_EY56 under the drop-down menu should pull-up RCY-EY56's corresponding pivot chart.)
I cannot upload the data due to privacy concerns, so please ask if you want me to elaborate on my question.
Thank you for your time.
-Door
