How can a custom view be copied from one tab to another tab in Excel 2010 and Excel 2013. Once the data is copied from one tab to the next, when clicking on custom view it brings me back to the original tab.
Further details: I've created custom views in my first Worksheet and am now trying to copy the same custom views into additional worksheets. I need about 30 worksheets in each Workbook, which all need to have the same custom views as well (Currently when you select a custom view from one of the Worksheets that was copied from the original, Excel returns you to the original page). Is there a way to copy custom views from one worksheet to another?