Pascale,

Right Click on the cell that has the value you want to copy and select copy.

Got to the cell that you want to paste and right click, select PASTE
SPECIAL. This will present you with other options, select VALUE.

This will result in the value being copied, however, if the original cell
value changes than you will have to do the above again.

If you want you new destination cell to change if the initial cell changes
then assuming that the cell that has the value of the sum total is in C20,
and you want to replicate this value in cell b20, then go to b20 and type in
=c20.

HTH


"Pascale" wrote:

Hello
How can I copy/past only the result of using the subtotal in the data menu.
For the moment, if I do a subtotal and want to copy somewhere else the
result of what I am counting (by clicking on the left handside of the screen
on number 2) I end up copying all the data in between. Is there a way to just
copy the results please. I work with 2003 version
Many thanks ahead