Hi all

I have a large worksheet and have added a few sub totals to it. I have
collapsed the data to the level I require and need to send this data to a
colleague, however, I do not want them to see the rest of the information.

If I simply copy and paste the worksheet, it copies the info in the
background too.

Is it possible to copy only the information you can actually see on the
screen?

Any urgent help would be appreciated.

Thank you.
Louise