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?