Monitor column for specific change in a cell then run macro if meets criteria

[Jockster]

When "charge" is selected from a dropdown in a column, the details of that row on Sheet 1 are copied to the next available row on Sheet 2. This works fine.

On Sheet 1, if the user then retrospectively changes "charge" on any row to something else, currently nothing happens.
What I'd like to happen is to:
a) establish that the string "charge" was in the cell and has been changed or deleted;
b) identify the same row of data on sheet 2
c) alert the user that they will have to add some notes to Sheet 2 via a message box or user form
d) take the user to Sheet 2 and the correct row to allow them to add some notes.

Any suggestions welcomed!

 

[mumps]

In order to do what you want, each row on Sheet1 must have a unique identifier. Are the values in any column in Sheet1 unique? It would be easier to help if you could use the XL2BB add-in (icon in the menu) to post a screen shot of your data in Sheet1.