I will take that as a "Yes it made things clearer" :)

LeAnne wrote:
Andy,

Oh...my...God.

That is absolutely brilliant. BRILLIANT, I say!

By the power vested in me, I hereby dub thee DA MAN.

Thankyouthankyouthankyou!!!!!!!

Cheers,

LeAnne


Andy Pope wrote:

Hi LeAnne,

Hopefully this will make things clearer.
http://www.andypope.info/ngs/ng35.htm

If I have mis-understood let me know.

Cheers
Andy

LeAnne wrote:

Andy Pope wrote:

Hi,

Could you not use an additional column that is a copy of the
Definition, call it masterdefinition. This column can be hidden.
Then when the user changes the definition you can use a CF to test
their definition against masterdefinition.

Cheers
Andy


Andy, not sure at all that I follow you. How could "Smith" be tested
against "The last name of the person to whom questions about the
sample should be directed"? Other than cofirming that the replaced
defitintion ISTEXT or something.

Puzzled,

L.




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info