I have a table of people and their activities. I have no trouble adding new
people but have a problem on deletion. If I delete a row there is the problem
of #REF! in formulas and also the tables below are moved. I think clearing
contents and copying and moving up the information below is the answer. I
have trouble with the code. Can someone help me?