Tim,  from my experience with Excel, if you have a second worksheet that
looks for data from another workseet you need to be careful with the sort
option.

I have a spreadsheet with 10 worksheets and I always have to make sure the
main worksheet is sorted correctly or the data on the dependant worksheet
will not calculate correctly and then I have other issues; such as trying to
explain my data to management (not a good thing).

So, I don't believe you can do what you want to do. But, you might do a
search in Google for websites that deal with Excel.  In the past I've found
a couple of boards that helped answer some of my questions.  Just a thought.

Good Luck,

Larry B.


>From: "Atwood, Tim (DVM)" <[log in to unmask]>
>Reply-To: "Atwood, Tim (DVM)" <[log in to unmask]>
>To: [log in to unmask]
>Subject: [HP3000-L] OT: MS Excel - Same Data, Different Views
>Date: Fri, 3 Oct 2003 15:12:44 -0700
>
>Wildly off the HP3000, but at least is computer related :-)
>
>Does anyone know how in Excel to have the same data (same column format and
>everything else), but have two different sorts and subtotal breaks?
>
>Essentially I was looking for having the first sheet in the workbook be the
>main one where any changes are made. Sheet1 would be sorted one way with
>corresponding subtotals on the sort breaks.
>
>Sheet2 would have the same detail data. But it would be sorted differently
>with different subtotal breaks. Any changes made to Sheet1 would update
>Sheet2
>
>Is this possible? Can anyone point me in the direction of how to do it?
>
>I suppose I could record scripts and set up macros to switch between the
>two
>sort/subtotal views on the same sheet. But I am a little reluctant to do
>this with something going out to unsophisticated users. The virus
>protection
>will tell them macros might be dangerous. Or I would need to go through the
>whole certification thing on all the macros, etc.
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

_________________________________________________________________
Frustrated with dial-up? Get high-speed for as low as $29.95/month
(depending on the local service providers in your area).
https://broadband.msn.com

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *