Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
That's got it! Thanks very much David.
Cheers again, Gregg. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link website data to Excel cells | Excel Discussion (Misc queries) | |||
How to link cells? | Excel Discussion (Misc queries) | |||
Can you Link 3 cells into 1 in Excel 2003 | Excel Worksheet Functions | |||
Can I link cells to a reference table I make? | Excel Discussion (Misc queries) | |||
Put same data in cells on two different worksheets (link?) | Setting up and Configuration of Excel |