There is a way to copy just the visible data. Before you copy the summary totals (or data), choose Edit, Go To; click the Special button; and select the Visible Cells Only option. Next, select the cells that contain your summary and continue with your copy routine. Excel will paste only the visible cells to the target range.
There is a way to copy just the visible data. Before you copy the summary totals (or data), choose Edit, Go To; click the Special button; and select the Visible Cells Only option. Next, select the cells that contain your summary and continue with your copy routine. Excel will paste only the visible cells to the target range.

