Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop Down List
Is there a way to have the drop down list change automatically without
manually changing it? I currently have a drop down menu in H13 of my summary worksheet that has the months of the year. Depending on which month you select, different information appears in summary worksheet. I would like it to always be automatically set for last month's stats, but currently I have to manually pick the correct month from the drop down list. Is there a way for when the months change, it will automatically pick up the month's data I would like? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop Down List
It sounds like all your tabs are grouped. Right click on your tab, and select
Ungroup Sheets. As far as undoing changes, close the file without saving, then re-open. -- ** John C ** Please remember, if your question is answered, to check the YES box below. It helps everyone. "Susan" wrote: Is there a way to have the drop down list change automatically without manually changing it? I currently have a drop down menu in H13 of my summary worksheet that has the months of the year. Depending on which month you select, different information appears in summary worksheet. I would like it to always be automatically set for last month's stats, but currently I have to manually pick the correct month from the drop down list. Is there a way for when the months change, it will automatically pick up the month's data I would like? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop Down List
That didn't work :-(. I do not currently have any formulas associated with
the drop down list, I currently select which month's data I want shown (which is linked to other sheets) I just don't want to have to go up and choose the date. I want it to automatically know that if today is 10/22/08, it should be showing September 2008's data - kind of =today()-30, but I don't know how to do that in relation to a drop down menu. I had to use a drop down list because that was the only way I could figure out how to connect conditional formatting from another worksheet. "John C" wrote: It sounds like all your tabs are grouped. Right click on your tab, and select Ungroup Sheets. As far as undoing changes, close the file without saving, then re-open. -- ** John C ** Please remember, if your question is answered, to check the YES box below. It helps everyone. "Susan" wrote: Is there a way to have the drop down list change automatically without manually changing it? I currently have a drop down menu in H13 of my summary worksheet that has the months of the year. Depending on which month you select, different information appears in summary worksheet. I would like it to always be automatically set for last month's stats, but currently I have to manually pick the correct month from the drop down list. Is there a way for when the months change, it will automatically pick up the month's data I would like? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Drop Down List
Sorry, my post got attached to your response in error. My response was to
some other question. That being said, what exactly are your formulas currently? What is in the pulldown menu, and where are you selecting the month from. For that matter, what is the layout of the data that you are drawing from. -- ** John C ** "Susan" wrote: That didn't work :-(. I do not currently have any formulas associated with the drop down list, I currently select which month's data I want shown (which is linked to other sheets) I just don't want to have to go up and choose the date. I want it to automatically know that if today is 10/22/08, it should be showing September 2008's data - kind of =today()-30, but I don't know how to do that in relation to a drop down menu. I had to use a drop down list because that was the only way I could figure out how to connect conditional formatting from another worksheet. "John C" wrote: It sounds like all your tabs are grouped. Right click on your tab, and select Ungroup Sheets. As far as undoing changes, close the file without saving, then re-open. -- ** John C ** Please remember, if your question is answered, to check the YES box below. It helps everyone. "Susan" wrote: Is there a way to have the drop down list change automatically without manually changing it? I currently have a drop down menu in H13 of my summary worksheet that has the months of the year. Depending on which month you select, different information appears in summary worksheet. I would like it to always be automatically set for last month's stats, but currently I have to manually pick the correct month from the drop down list. Is there a way for when the months change, it will automatically pick up the month's data I would like? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
drop down list in Excel | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |