Workbook design help

[Xenoun]

Hello,

I have recently completed a workbook that trends a fair amount of data for a specific group. In total I have 13 of these groups with data that needs to be trended, and I plan to use the first one as a template.

Ideally I would like to be able to click a drop down menu, have it display all the groups and then when I click on the desired group it will bring up the trend graphs.

Does anyone know what the best method would be to achieve this? My first trend workbook uses four sheets, and requires a button to be pushed that updates data that it grabs from the master workbook. The button also updates a few formatting fixes and a pivot table.

Any suggestions would be helpful, i'm not really sure how to go about doing this due to the nature of the spreadsheet. I'll also have to look into how to construct a drop down menu

 

[sijpie]

There are a number of options.
The simplest is probably to preapre al the graph sheet permutations. Then hide them all. When selecting a certain group, only the valid sheet(s) are then unhidden and available.

This is simple to achieve with

sheets("yoursheet").visible = false  ' hide
'or
sheets("yoursheet").visible = true  ' make visible

First create your set of macros to hide/show the relevant sheets

then somewher in your spreadsheet (on a hidden sheet) have a table with the 13 group names. Name the list

Then from the Forms controls select the combobox paint it on your home sheet somewhere and link the form to your selection macro

 

[Xenoun]

Thanks for the reply. From what you've said it seems like I should dump the 4 sheets from each group into one workbook and just have the sheet with the graph appear and update when the person selects that group

Can you confirm whether i've understood that correctly or if you're meaning something else?

 

[sijpie]

Yep, that is what I meant.