It can probably be done using worksheet event code but...........

So far the only item that has been changed is the item "Contracted".

Do you want that word copied to another sheet named Contracted Projects?

Must be more to this than what you describe.


Gord Dibben MS Excel MVP

On Mon, 8 Mar 2010 13:47:01 -0800, Chris
wrote:

I have a worksheet with Validation rules set. But what I need to set is a
Macro that runs when the Validation Item List is changed to “Contracted” I
would like it to Copy the item that was changed to a Sheet set as Contracted
Projects. How can this be obtained?