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.
Moderator Note: Cmb80, welcome to IT Knowledge Exchange. Please provide enough detail when you post a question so that other members don't have to guess. Are you using Microsoft Excel? DataGrid? Visual Basic? Visual Basic for Applications? Whenever you need to add more info to a question - you can add a comment to your original question to explain. Thanks.
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!
Discuss This Question: 1  Reply