Hi all. I have a worksheet that is basically a form that users fill out.
Column A has projects listed down the column. Columns B through CA have
names of people assigned to projects.

So in A1 is ProjectA. In B1 the name Bob, In C1 the name Bill, in D1 the
name Joe, etc..
Columns B through CA are pick lists created from DataValidation. In the
datavalidation list, I have code that, when a name is removed from the
list, the code removes that name from the front table. So if Bob is removed
from the list, the code clears the contents of cell B1.

This leaves a blank cell, followed by populated cells, and each row will be
different. My question is this - is there a way to add to the code so that
when a name is removed, all cells shift to the left filling in the blank
cells? It can be one macro that will examine the entire sheet (or a
specified range) and shift everything to the left appropriateply?

Thank you!!