Drop down box

[drewszone32]

I have a summary page with set up with Months listed on top and groups listed on left side. Below I have a drop down box which brings up each months information.

I would like to be able to bring up January and have the information populate in summary section for January in upper section of excel sheet and when I change to February January's information above stays and the February information is populated above in February's section.

I hope this makes since. Kind of like this.

[pre]

'			Summary
Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Bc
ac
dr
gt
hs
drop box with each month

'			Information
1	2	3	4	5	6	7	8	9	10	11	12
Bc
actt
dr
gt
hsts
bbbb
dddd
ac
hs
cccc
sdwt
adsw
sdwer

[/pre]

 

[Luke M]

I don't understand what the drop box is doing. Are you only showing 1 month's worth of data at a time? How exactly are the two tables you show in your example related?

 

[jeffreyweir]

drewszone32 - I'd suggest just use a pivot table...are you familiar with them? Note that using a pivot means you'll have to restructure your data slightly, but it would likely be worth it.

 

[drewszone32]

The drop down box is used for the bottom section. When you click on drop down box you can pick any month, which will bring up that month's information from other tabs into one. I would like to be able to bring up any month's information from drop down box and it will fill the top part for category by month.

 

[SirJB7]

Hi, drewszone32!

This is the second time that I read this topic and I'm still unable to understand your requirements.

Consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you. Give a look at the green sticky posts at this forums main page for uploading guidelines.

Regards!