Hi, I was hoping I could get another macro that copies a formula into a cell based on the month, but only when I tell it to make that change. I have included a small worksheet to illustrate what I am doing, but it is basically this. We want to put the actual cost into the “current” row as the months move on through the year. I have a special Vlookup formula already created that does this for me, but I do not want that formula in the “July” column when I am working in this file in March. What I am trying to say is, if it is the actual month of March then I want the March column to have my formula but not April – December. When it is April I will change the month word to April, then I will go and run this macro that over writes what is in April and puts in my formula in April. It does not matter if every time it puts the formula in it over writes it in the previous months formulas, as it will be the same formula, but I want to avoid writing over the future months formulas.

The formula I need copied is this:

=VLOOKUP($B4&$BX$18,Actuals!$C$3:$P$10,Actuals!D$1,FALSE)

Thank you, thank you so much for any help you guys can share, I am most appreciative of the help I have received on this site.

## Bookmarks