Excel Drop Down List

[Susan]

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?

 

[John C]

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.

 

[Susan]

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]

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.