Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Problem
I have a workbook with 3 worksheets. In column A of wksht 1, I type employee
names. In column A of wkshts 2 and 3 I have = to then the cells in wksht 1, so I only have to type the names one time. So when I add a new employee it automatically adds it to the other pages. My problems is when I sort the names into alpha order. I need other columns in wkshts 2 & 3 , to follow the sorting of names. Is there a way to to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Problem
I have a workbook with 3 worksheets. In column A of wksht 1, I type
employee names. In column A of wkshts 2 and 3 I have = to then the cells in wksht 1, so I only have to type the names one time. So when I add a new employee it automatically adds it to the other pages. My problems is when I sort the names into alpha order. I need other columns in wkshts 2 & 3 , to follow the sorting of names. I tried this in Excel 2003, and it already works the way you want. I used Data Sort to do the sorting. If you don't use Data Sort but instead manually insert/delete cells/rows in wksht 1 or use cut-paste, you won't get the result you want. In that case, a different approach is needed; for example, using something like =INDEX(Sheet1!$A:$A, ROW(), COLUMN()) in wkshts 2 & 3. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Problem
I have a workbook with 3 worksheets. In column A of wksht 1, I type
employee names. In column A of wkshts 2 and 3 I have = to then the cells in wksht 1, so I only have to type the names one time. So when I add a new employee it automatically adds it to the other pages. My problems is when I sort the names into alpha order. I need other columns in wkshts 2 & 3 , to follow the sorting of names. I tried this in Excel 2003, and it already works the way you want. I used Data Sort to do the sorting. If you don't use Data Sort but instead manually insert/delete cells/rows in wksht 1 or use cut-paste, you won't get the result you want. In that case, a different approach is needed; for example, using something like =INDEX(Sheet1!$A:$A, ROW(), COLUMN()) in wkshts 2 & 3. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting problem 10 comes before 8 | Excel Worksheet Functions | |||
Sorting problem | Excel Discussion (Misc queries) | |||
Sorting problem | Excel Discussion (Misc queries) | |||
sorting problem | New Users to Excel | |||
Problem Sorting | New Users to Excel |