link row cells

G

Gary

Is it possible to lock the information in a row together
and have it stay together when sorting one column?

Data goes from A2:X2, I want to beable to sort column
B2:B52 and have that row 2 information and all rows
follow the sort no matter where it ends up in the sort.
Row 2 follows B2, Row 3 follows B3 no matter where it
might end up in the sort.

Gary
 
D

David Biddulph

Gary said:
Is it possible to lock the information in a row together
and have it stay together when sorting one column?

Data goes from A2:X2, I want to beable to sort column
B2:B52 and have that row 2 information and all rows
follow the sort no matter where it ends up in the sort.
Row 2 follows B2, Row 3 follows B3 no matter where it
might end up in the sort.
Click to expand...

Select A2:X52
Data menu/ Sort
Sort By: Column B
 
Top