| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting data does not expand to other sheets
Hi. I am looking for a way to maintain data on multiple sheets if I sort.
For example: Sheet 1 A B 1 k blue 2 m green 3 c red Sheet 2 is A B 1 =sheet1!A1 circle 2 =sheet1!A2 square 3 =sheet1!A3 oval Every time I sort column A in sheet 1, column A in sheet 2 does as well, but the sort did not expand to the data in column B sheet 2. Is there a way around this? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expand Selection in Multiple Sheets | Excel Discussion (Misc queries) | |||
| Sorting data in protected sheets? | Excel Discussion (Misc queries) | |||
| Sorting Data from 2 sheets, one sheet which is already sorted | Excel Worksheet Functions | |||
| Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
| Sorting Data to Different Sheets | Excel Worksheet Functions | |||
Threaded Mode
