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.
|