| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
same range, multiple sheets, different sorts, help please!
I have a range of data that I would like to sort with different criteria on different sheets: in other words I want sheet 2 to be sorted by disc number, sheet 3 to be sorted by job number, and sheet 1 to be a kind of master list sorted alphabetically. Is there a way I can link these sheets so that any updates I make on Sheet 1 will automatically be reflected on the other sheets and sorted correctly? I'd like to make it easy to make changes to these lists without having to update each one. Any help is appreciated. -- nikmasteed ------------------------------------------------------------------------ nikmasteed's Profile: http://www.excelforum.com/member.php...o&userid=32318 View this thread: http://www.excelforum.com/showthread...hreadid=520744 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
same range, multiple sheets, different sorts, help please!
any ideas, anyone? -- nikmasteed ------------------------------------------------------------------------ nikmasteed's Profile: http://www.excelforum.com/member.php...o&userid=32318 View this thread: http://www.excelforum.com/showthread...hreadid=520744 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How am i able to populate a sumation for multiple sheets | Excel Worksheet Functions | |||
| Matching Multiple Sheets | Excel Worksheet Functions | |||
| Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
| Can I unhide multiple sheets at once? | Excel Discussion (Misc queries) | |||
| How do I unhide multiple sheets? | Excel Worksheet Functions | |||
Linear Mode
