What is actually in A6... A real date formatted to show only the month or
just the text (letters) that make up a month's name? If just the text is
entered in A6, is it **always** the full month's name, an abbreviation for
the month's name or the month's number? Note the word "always" that I
used... I'm looking for what possibilities are entered in A6.

--
Rick (MVP - Excel)


"pdgarza" wrote in message
...
I need to create a macro but am not real sure how. Here is what I am
trying
to do.

In cell A6 is the current month. In cell A9-A22 I have a formula.
Columns
E-P represent September-August (Sept is column E, October is column F,
etc).
In cell E9-E22 (Sept), F9-F22 (Oct), etc. is the same formula that is in
cell
A9-A22. (the formula is supposed to change depending on the month that is
in
cell A6).

So I need to figure out a macro that if A6= September, then A9-A22 will =
E9-E22 (september data), and if I change A6=October, then A9-A22 = F9-F22
(october data), etc.

Thank you in advance!