Do your data|subtotals
use the outlining symbols to the left to hide all the details
select the range to copy
Edit|goto|special|visible cells only
edit|copy

off to the other sheet
edit|paste



Neophyte wrote:

Is it easily doable to have the subtotals from sheet 1 calculate (show?) on
sheet 2? I have used the Data-Subtotals to get what I want on the sheet but
when I want to copy only the subtotals to another sheet, I get all the
cells. I have been exporting the info to Access and then doing a selective
import and filter and then exporting it back to Excel. Very round about and
clumsy.
Thanks you very much for looking and any answers.
Lee

--

Dave Peterson