Run a macro based on the value of a cell

From: Coyote (Coyote_at_discussions.microsoft.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 11:39:07 -0800

Hi Everyone

I have what seems to be a simple task but can't seem to figure it out. I
have a excel file that has the tabs "Current User List" & "Prev User List"
On these sheets the first row is called "status" which is either "curr" or
"prev" to indicate employee status. I copied and modified the macro posted
on this site for copying an entire row to another wor*** and it works fine
but I'd like to go one step further. If I change the status of an employee
on the "Current User List" to "Prev" I want the macro to run so that the
record is copied to the "Prev User List automatically.

Any help would be greatly apprciated.