#1
|
|||
|
|||
sheet linking, sorting
I have a range of data that I would like to organize onto three different sheets, all with the same data but simply sorted by different criteria (i.e. sheet 1 alphabetical, sheet 2 job number, etc.). Is there a way to link all the sheets to sheet 1, so that if sheet 1 is updated, the other sheets will be automatically updated and sorted properly? Any suggestions or ideas would be helpful. I have only intermediate knowledge of Excel. Thanks.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking from Excel to Word | streng | Word | 4 | 10-28-2008 08:23 AM |
Setting up Analysis Sheet when data does not exist, yet. | burnoutdetective | Excel | 0 | 10-13-2008 05:57 AM |
Sorting Tasks by Contacts | Bat | Outlook | 0 | 09-24-2007 01:20 PM |
Risks and Issues - linking to other than the default | Rkramkowski | Project | 0 | 08-07-2006 07:08 AM |
Enter Number on any sheet one time only. | paulrm906 | Excel | 1 | 04-28-2006 07:35 AM |