Link 2 cells together

[gcbrit]

Hi all,

I would like to link 2 cells together so that when I sort one column
alphabeticaly, the other column containing numbers will move with them.

I'm trying to create an alphabetcal list of spark plugs at work where
one column (B) contains the part number (i.e BKR6EK) and the other
column (C) contains the corresponding stock number (i.e 2288). So when
I sort column B I need the numbers in column C to alter accordingly
too.

Any help would be great!

Gregg.

 

[Guest]

On the toolbar select

Data>Sort...sort by cloumn B and by column C.

 

[gcbrit]

That's got it! Thanks very much David.

Cheers again,

Gregg.