Develop Macros to Display Costs for Each Month (VBA)

[Stryker152]

Hello,

I developed two macros that insert a function into a cell only if two cells' dates are equal to each other. If this is true, the macros will divide the annual cost by 12.

Here are the two macros:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The solution as a result from the macros is displayed in GREEN.
An example of the table is attached to this email.

I am trying to develop code that will add the previous month's cost into the next month's cost value which would represent the RED cell values in the table. It will be ending with the 12th month after the GREEN cell which would equal the annual cost.

Any help would be greatly appreciated.

[alansidman]

Code Tags Added
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.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[Stryker152]

Sorry for the mistake, and thanks for making the correction. Also, would you be able to help me with my problem?
Thanks.