I have a file with tabs for each of our office locations, (TAM, STP, ORL,
Etc),that lists user information for the employees in each office. One of
the cells is a drop list of each of office location, (i.e. TAM, STP, ORL). If
an employee moves to another office I'd like to be able to select their new
office location from the drop list and have the entire row moved to the
appropriate office tab.

Thanks in advance for your help
Coyote