I repeat the question - Linked cells and the sort function

[Barbara]

Not sure how this posting process works and I guess I am a
bit impatient, but I need help with this problem.

I have set up a worksheet with project names/numbers
(column for each). On the next worksheet, I pasted this
information as linked data and added additional columns
for descriptions. When sorting the first worksheet, the
linked columns sort appropriately, but the column with the
descriptions does not sort. Therefore, the descriptions
are not aligned with the correct project name/number.

Is this possible?
Thanks,
Barbara

 

[Danny]

When you sort, try higligting all the columns.

 

[Dave Peterson]

How did you link the cells?

Did you do something like =sheet2!b3

If yes, try using =Vlookup() to match a key between your key column (project
number???) of both sheets.

=vlookup(a1,sheet2!$a$1:$b$9999,2,false)

if A1 contained the project number, sheet2 range a1:b9999 contained the table of
project numbers (in A) and descriptions (in B).