Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |