I am using "Custom View" to help users of a shared a Workbook to sort and filter data quickly on a large data table with Multiple Sheets. The Workbook is a Scheduler what uses Status Codes to sort Sales Order by STATUS and Customer SHIP DATE. The problem is when I ADD a Custom View on Sheet 3 it also creates a view of all the other Tabs in the workbook. So if I have a data table with all my data Sheet 1 on it and create a Custome View and run it by use of a Macro and then go to Sheet 2 data table and create another Customer View it will change Sheet 1 back to the custom view named early. As we switch back and forth Sheets we have to continue to reset or filter the data set because of Custome Views of another Sheet. Can Custom View only be assigned to individual Sheets? OR is there a better way to set up views to have them be independent?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
"Custom View" Changes Views on a Workbook with Multiple Tab's/Sheets
Similar threads
- Question
- Solved
