rsrasc
11-11-2023, 09:04 AM
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!
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!