Home > IT Answers > Development > Copy and paste values based on a column
Cmb80
10 pts.
 Copy and paste values based on a column
Visual Basic
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.

Software/Hardware used:
ASKED: April 21, 2009  9:03 AM
UPDATED: April 21, 2009  12:49 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

BrentSheets
 6,580 pts.