Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i link specefic cells?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i link specefic cells?
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. DataSort 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-Pro "Randy" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can you link images to cells? | Excel Discussion (Misc queries) | |||
Link picture between cells | Excel Worksheet Functions | |||
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 |