David,

Thank you for the quick response. I am not an Excel person at all, but I
will try.
I am connecting to a database where I get my information from. It populates
my cell with the information. The information is basically my groups tasks.
For me to keep track I would like to assign a person to that task. If I
update later again new task are added or deleted. First part is that when the
new task comes in the spreadsheet gets updated and the names get out of sync
to the task their were assign to. By that I mean if column 1 has all the
information and at the last row I put a name John then new data comes in John
is now assign to that task. His name does not follow the correct column.

The other part is when I update the data and the ticket is close John is now
link to the wrong column. I hope this makes more sense now.

Thanks again

Kenny