Hi Homer

display only the subtotals on the screen and click on one of them
choose edit / goto, click the Special button
select
visible cells only
click OK

now COPY and PASTE as usual.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Homer" wrote in message
...
Hi

I want to copy the subtotals only from one sheet to another, there must be
a
way??

Thanks

Homer "D'oh"