Ok Judy, you are coping the entire figures, as the rows are hiding,
try to select the area, press F5 click on the Special botton, select visible
only.

hope this helps
regards from Brazil
Marcelo

"judybart" escreveu:

where is the subtotal copy?- if i use the regular copy & paste special
-values i still paste all the supporting date not just the subtotal rows

"Marcelo" wrote:

Hi Judy,

select the subtotals copy and paste special as values



"judybart" escreveu:

i only want to copy & paste the subtotals, not the supporting data

thanks