If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linked Documents
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? |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|