Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting in multiple worksheets
I'm having a few issues sorting rows in multiple worksheets. I have 6
worksheets with Names in one column and employee numbers in another. I have these linked throughout all six worksheets. When I sort the rows in my worksheet A it sorts the linked cells brillantly throughout the rest of the worksheets. However, I have data in the worksheets B-E that relates to the specific employees name in the row. When I sort the related data does not stay with the specific employee's row in worksheets B-E. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting in multiple worksheets
If you select all columns before doing the sort, all data will stay
together. But since you have some columns linked in sheets B-E and some not linked, the not-linked cells will not sort when you sort sheet A. Only the linked cells will follow sheet A's sort. Gord Dibben MS Excel MVP On Wed, 2 Dec 2009 15:36:01 -0800, GWVF wrote: I'm having a few issues sorting rows in multiple worksheets. I have 6 worksheets with Names in one column and employee numbers in another. I have these linked throughout all six worksheets. When I sort the rows in my worksheet A it sorts the linked cells brillantly throughout the rest of the worksheets. However, I have data in the worksheets B-E that relates to the specific employees name in the row. When I sort the related data does not stay with the specific employee's row in worksheets B-E. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting/Working across multiple worksheets | Excel Discussion (Misc queries) | |||
need help sorting records over multiple worksheets | Excel Discussion (Misc queries) | |||
Sorting Multiple Worksheets | Excel Discussion (Misc queries) | |||
sorting multiple worksheets | Excel Worksheet Functions | |||
Sorting multiple worksheets simultaneously | Excel Discussion (Misc queries) |