I maintain a daily roster of names, work assignments, shift times, etc. Each person's data is in a row.

I need to be able to manually delete the cell contents marked "Last Name" and certain other individual cells in that row will clear their contents automatically.

Other cells in that same row will retain their contents.

Of course, a simple formula in the cells to be cleared would be over-written as data is entered...