Logical test question
I need a formula that says, "Hey, the data entered in cell D6 is =/ 50,000,
so I need to copy all of Row 6 and paste it into another worksheet". Is that
possible? It seems like it would be. But I think that the formula needs to be
in D6, and not in the other worksheet. Would I be better off to record a
macro? And if so, can the IF function be pasted into a macro?
|