Work sheet event can be used. or helper columns are to be used.
Which one you prefer.