Turn on the Macro Recorder: Tools Macro Record New Macro. Then click
through the steps as usual.

Take a look at this:
http://www.anthony-vba.kefra.com/vba...ur_First_Macro

Regards,
Ryan---

--
RyGuy


"pdgarza" wrote:

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!