I need to copy and paste the values of specific rows in colums H,I and J if column D = "X".
At the moment columns H, I and J contain a formula if column D doesn't equal "X". Once column D becomes an "X" -I need the result of the formula in H, I and J to be fixed ie - the result of the formula and not the formula itself.
The problem is, that rows 2,3,6 maybe "X" but 5 and 6 are not "X".
Please advise how/ if this can be done using a visual basic macro.