VBA to drag formulas into next blank column and hard paste the figures in previous section

[malikumair56]

Hi guys,

I am a noob in VBA but love playing with it, i am after a code which can copy a formula from one column and paste the formula in the next column, once done then hard paste the figure in previous column where the formula was first dragged from.
I tried using MACRO by recording but that wont help as that will only repeat from the same column rather then moving to next column.
FOr example, i have billing per month and also revenue per month, Billing for Jan is in Column N and Revenue for Jan is in column AB, once the month end is done, to start a new month, i want the VBA to drag the formula from Column N to column O and same for Column AB to Column AC and once the ula is dragged, hard pasted the figures in Column N and Column AB.
Pic is attached for reference. Thanks in advance

 

[malikumair56]

No luck, got this error. Actual is in row 5.

 

[MARK858]

That error says the word isn't there Check for spaces around the word.

 

[malikumair56]

It worked thanks, i believe i had a data validation between actual and forecast which might be causing the e
i removed data validation and it works great now. thanks Mate.
You are a gem

 

[MARK858]

You're welcome

 

[malikumair56]

Sorry one more issue now. Billing side is working but Revenue side is not working

Billing and revenue side works when i run VBA the first but when i run it agai after changing forecast to Actual billing side is fine but revenue side stops working

 

[MARK858]

That is because you have multiple Actuals after the one that you want. On the left hand side you have 4 Actuals before the Forecast, on the Right you have 7.
I am afraid I can't do anything with that as I can't code for inconsistent layouts.

 

[malikumair56]

Sorry, screen shot wont do justice, actuals are the same, reeason you are seeing 4 on left as i have freeze pane, left one is April if you count from Jan til July its 7 as well.
Layout is same
In this screen shot its same

 

[MARK858]

Afraid I would need to see the actual workbook rather than an image to see what your issue is.

 

[malikumair56]

Hey Mark, all sorted thanks

 

[MARK858]

Happy that you worked it out.