close

I have a simple spreadsheet that has 3 columns. the three columns contain
seperatly, thier name, Date of Birth and Date of Hire. I want to be able to
link the 3 cells together, so when i organize the information by name, DOB,
or DOH, the other cells move with it. Can anyone please offer assitance?

If I understand you correctly....you want to be able to sort by Name, DOB, or
Hire Date and have the corresponding data all move together.

If that's correct, try this:

Select your entire data list, including the three column headings.
Datagt;Sort
Click: My list has a Header Row
Select the sort field (Example: Name)
Click OK

The list will now be sorted by Name and the DOB and Hire Date for each name
will be sorted with it.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Randyquot; wrote:

gt; I have a simple spreadsheet that has 3 columns. the three columns contain
gt; seperatly, thier name, Date of Birth and Date of Hire. I want to be able to
gt; link the 3 cells together, so when i organize the information by name, DOB,
gt; or DOH, the other cells move with it. Can anyone please offer assitance?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()