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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!