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 *