Hi Angela

If you have used DataSubtotals then click on 2 to show only the Subtotals

1) Be sure that the active cell is in the data range
2) Press Ctrl * to select all data or use F5SpecialCurrent regionOK
3) Press Alt ; to select all visible data or use F5SpecialVisible cells onlyOK
4) Ctrl c or EditCopy
5) InsertWorksheet
6) Ctrl v or EditPaste
7) Select the sheet with the Subtotals
8) Press Esc


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Angela" wrote in message ...
I need to copy the result of a subtotal in a sheet without the data. I
cannot find the function Copy visible cells only.

Lost....