View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default 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?