VBA Code to Copy Info

[rsrasc]

Hello all,

In my previous post from today, I was using two similar VBA codes to copy across (to the right) the information showing in Column F for those rows showing “Budget” and % Change.

Since there are formulas in there, it works well for me.


So, I was trying to use some of that code to do something similar or do the same for the “Prior Actual” information showing in Column F but it doesn’t work for me.

In the attachment, I marked in yellow the cells that needs to be completed.

For example, the following cells has these values, and also there is a formula in there such as:

=IF(ISNA(VLOOKUP($C14,'FY 23 Actual + Reforecast'!$A$1:$AI$503,H$1,FALSE)),"$0.00",VLOOKUP($C14,'FY 23 Actual + Reforecast'!$A$1:$AI$503,H$1,FALSE))

H14 = 2,633.84
J14 = 2,883.55
L14 = 2,974.07
N14 = 1,886.85



And so on.

Therefore, with a macro I would like to copy just the values to the cells marked in yellow.

Not sure if the cell reference can be used, let’s say for example in cell I14, I would like to have the following value: =H14 and so on.

Thank you all for your assistance and cooperation.

Cheers!