View Single Post
  #2  
Old September 17th, 2003, 10:55 AM
Bill Manville
external usenet poster
 
Posts: n/a
Default Linked Documents

Shartman wrote:
Is it possible to link two worksheets and sort the 2nd sheet by a different
criteria then the first, at the same time any row/column that is added or
deleted in the origianl would be added or deleted in the 2nd sheet while
maintaining the separate sort criteria?


Short answer: no.
Longer answer: you probably could, by using VBA macros to remake the second
sheet whenever the first sheet is changed.

I would stick with one sheet and have buttons to switch between the two sort
criteria.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup