Macro for copy and paste column formula into another column

[AMoreno]

Hello,

In my file attached I am updating this particular piece of a bigger file. I am updating the financials monthly, and wanted to create a macro that would copy and paste the previous months formula over to the next month actuals (obviously I have the other information, just prepping for an easier process next year). However, there are only certain ranges that would need updated. Since I have to other sheets in the bigger file, I was going to create macro for each sheet such as dayschool, education, and residential (have dayschool in the attached file) since they each have different amount of ranges that need updated, I was hoping to have help on one and then I could adjust for the others.

Attached:
You will see that July-September are already updated with the actual in the sheet attached.

(in actual file it references another book and I use this formula below)

=IFERROR(INDEX('H:\PDE_pull\[12 MO ACTUAL.XLS]011000-030 - Acct Detail'!$A$1:$N$65536,MATCH($B12,VALUE(LEFT('H:\PDE_pull\[12 MO ACTUAL.XLS]011000-030 - Acct Detail'!$A$1:$A$65536,6)),0),MATCH(D$9,'H:\PDE_pull\[12 MO ACTUAL.XLS]011000-030 - Acct Detail'!$A$7:$IV$7,0)),0)

For the "dayschool" macro, I would like it to have on the next month, which in this case I have highlighted green where the cursor may go I guess and then have it copy and paste the Septembers formula into October in orange. Only the yellow highlighted section needs to be updated. Each month I would pull the new report into its folder and come to the sheet and use the macro, and it should then update it.

Like I mention before, due to big file already, I was just gonna save the macros within the workbook as we will continue to use it.

If anyone could help, it would be greatly appreciated

Thanks, Ant

[AMoreno]

Alrighty guys, just got my post moved over to this side of the thread from general wondering if I could have some help it would be greatly appreciated.

I have found one solution with my macro so far, but was unable to write it with range and copy function so I did it manually. Wondering if anyone could help clean up and consolidate the code so I could put towards my other sheets as well.

Current Macro:

Please Login or Register  to view this content.

Any help is appreciated. Like mentioned I would like to run the macro for all 3 sheets at one time but thought it would be easier to get down one sheet for the moment.

Thanks,
Ant

[AliGW]

Unfortunately, your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[AMoreno]

Okay I apologize, I wondered how others did that. All fixed and good to go. Thanks.