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!
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!