If you do this often, you may wish to place the icon on your toolbar.

Right click in the toolbar and choose "Customize", then <Commands tab,

Click <Edit in the left window, and scroll down to the next to last item in
the right window.

Click and drag it to your toolbar.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"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"