Copy and paste values based on a column

10 pts.
Tags:
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.
ASKED: April 21, 2009  9:03 AM
UPDATED: April 21, 2009  12:49 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BrentSheets
    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.
    6,875 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following