I need help creating a macro

[pdgarza]

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!

 

[ryguy7272]

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/vbabasic1.htm#Creating_Your_First_Macro

Regards,
Ryan---

 

[Rick Rothstein]

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.