If you have every copied cells in a range that has some hidden rows our columns you soon discover that the hidden data gets copied too. Same applies to other features including subtotals.
What would help is a command or button that allowed you to select only the visible cells so that only those are copied. Well thankfully there is a button for it but you have to add it to your toolbar or ribbon.
You can see how to do this in the tutorial below.