Excel Copying Visible Cells Only
If you try and copy a range of cells that has hidden rows or columns when you paste it will include the cells you have hidden, same happens if you use outlining which is useful in scenarios and subtototals, if you want to copy on those cells that are visible then you need to add a button to select visible cells.
If you want to know how to do subtotals which is mentioned then here is that tutorial • Excel: How to Use Subtotals
How to customize the ribbon • Customizing the Ribbon in Microsoft O...
Scenarios tutorial is here • Using the Scenario Manager to Create ...
Created by Gary Schwartz at www.jargonfreehelp.com