Link 2 cells together
 

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.

On the toolbar select

DataSort...sort by cloumn B and by column C.



"gcbrit" wrote:

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.

That's got it! Thanks very much David.

Cheers again,

Gregg.