XLplus Add-On: Copy Visible Cells
Using this tool you can copy all visible cells in a range or an outline to a new location.
In the example, rows 9 until 14 are not visible by settings of the outline. The dialog will automatically try to identify a contigeous data area. In this case, it correctly identified the data area B2:D23. Using option Skip invisible Rows the tool gets instructed not to copy hidden rows.
Afterwards, the target cell will be defined. By default this will be a cell below the last row filled with data. In the example this will be cell B28. Alternatively, you can specify a different workbook or -sheet. In order to determine another worksheet or a different target cell use button: 
Finally, the visible cells will be written to the target location. As can be seen, the hidden column C was copied as well. This happened because we specified to Skip invisible Rows, only. Since we cannot specify Rows and Columns at one time, we call the tool again and copy the data area just inserted. We specify option Skip invisible Columns this time.
We now have created an area which consists of the visible data only.
Note: You can paste data incl. functions. Please recognize, that not all functions will correctly work at their new location.
Versions:
Ver.: 2.0.9 and Ver.: 3.0.9: New.