You could probably use the Worksheet_Change event to do that, but the post lack sufficient info to offer any code for it.