I repeat the question - Linked cells and the sort function

  • Thread starter Thread starter Barbara
  • Start date Start date
B

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
 
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).
 
Back
Top