1. Is there any way to select a Data Area and save it for sorting similar to setting a Print Area for printing. 2. How can I have in the same worksheet, one sheet sorted one way and another sheet sorted another way so I can click between? And can I have the two sheets interlinked so a change in data on one sheet changes the other sheet? bob gillis

Bob, some suggestions on your queries: 1. Try copying and pasting to another worksheet (see the HELP file for the exact procedure to do that in Excel). 2(1). I presume you mean in the "same WorkBOOK"? Again, just copy and paste the needed Worksheet into a new WorkSHEET in the same WorkBOOK. You can then work on either at will. Again, see the HELP file for the exact procedure to do that in Excel (somewhat different to normal "copy and paste"). 2(2). WorkBOOKS can be linked and you will find some help from Microsoft on this site: http://tinyurl.com/6dhvt If you do not get sufficient information there, do a search using (1) "link workbooks" or (2) "link worksheets" in www.google.com It is a rather complex topic and I guess the best way would be to borrow a book on Excel from a nearby library. That's how I get most of my answers on Excel problems :-). Lance -----Original Message----- From: bob gillis [mailto:rpgillis@bellatlantic.net] Sent: Monday, 19 July 2004 22:05 To: GEN-COMP-TIPS-L@rootsweb.com Subject: [Gen-Comp-Tips] Excel 2000 More Sorting Questions 1. Is there any way to select a Data Area and save it for sorting similar to setting a Print Area for printing. 2. How can I have in the same worksheet, one sheet sorted one way and another sheet sorted another way so I can click between? And can I have the two sheets interlinked so a change in data on one sheet changes the other sheet? bob gillis --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 0430-1, 2004-07-19 Tested on: 21/07/2004 2:48:55 PM avast! - copyright (c) 2000-2004 ALWIL Software. http://www.avast.com