This is an over simplified example. You would select the cell to be revised
and
then trigger the macro.

Sub fixit()
newData = InputBox("Enter corrective data", "CORRECTION")
Selection.Value = newData
End Sub

The example is merely to illustrate how to replace data in a cell using
code. If you incorporated this principle into a macro that performs an edit
to find discrepant items then it would be useful.

"Magoo" wrote:

On Feb 25, 5:20 pm, JLGWhiz wrote:
Part one is not practical with a Message Box.

In part two, you could probably write some code to use an input box and
update the status of Items that you find needing it during your edit. It
would not be automatic. You would have to have a separate macro to run the
updates but you could Identify those needing updating with the edits and then
start the update macro to complete the task.


Could you provide an example?