I have tried to post this question on various groups, but it didn't show up,
so I am posting it here.
Any help would be greatly appreciated.

I have a worksheet with columns A and B. Both coulmns contain Texts.
Col A contains project names and Col B contains Comments.
Col A is updated automatically from another sheet based on some conditions.
Col B comments are manually entered by project managers.
I need to link the comments to the Project name such that next time when
project name moves up or down col A, comments owuld move up or down with it.
My formulas for updating col A work fine. Project names list is updated
based on their stauts. But comments entered from last time are misaligned
with the new list.











"Tyro" wrote:

I have posted this in the newsgroups. No one will answer. Will you look at
my question, please?

If so, I will post my question.