Hi there

Is it possible to only copy unhidden rows? I have spent ages hiding rows so
that only sub total amount appears, but when I copy into a new sheet all the
hidden rows copy at the same time :-(

thanks

Cathy