Sounds like you could use pivot tables.  You can have multiple pivot
tables in the same workbook (different worksheets) accessing the same
source data.


On Fri, 3 Oct 2003 15:12:44 -0700, Atwood, Tim (DVM)
<[log in to unmask]> wrote:

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

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