Copy and paste values based on a column

Cmb80

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 Last 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.

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.

BrentSheets Apr 21, 2009 12:48 AM GMT

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,950 pointsBadges:

report