Hey Folks,
I've read a ton of posts on this subject and tried a few of the solutions provided, but I couldn't get them to work in my Excel 365 spreadsheet.
I am trying to accomplish hiding subsequent tabs based on a cell value of another tab. I believe I must create all the maximum number of tabs possible and hide those that are not required? Maybe I'm going about this backwards.
Sheet 1 contains top level tasks. The user can enter 1 to 30 separate tasks, (column A6:A35). The user enters starting at row 6, then 7, then 8 etc. User will never enter row 6 then skip to row 12.
Each of those 1-30 tasks then has it's own sheet(tab). So far a maximum tab count of 31 if they enter all 30 tasks. If the user only enters 4 of the possible 30 tasks on sheet 1, I only want to display a total of 5 tabs, and hide the tabs that are not needed.
To complicate it further, each of the 4 entered tasks has it own task list of up to 50 tasks and the same thing, if they only enter 43 tasks, I only want to show the 43 tabs and hide the other 7 not including already showing the 4 of 30 tabs
Maybe this could be better described as drill down, or a drill up, I don't know anymore
. Each level drilled down to, gets potentially larger.
To reverse engineer it, I have 5 to 1000 tasks which roll up into 1 to 50 tasks which roll up to 1 to 30 tasks which are listed on tab 1. How do i only display tabs that need to be shown because the task it comes from has data.
Have you guys got an ideas?
I've read a ton of posts on this subject and tried a few of the solutions provided, but I couldn't get them to work in my Excel 365 spreadsheet.
I am trying to accomplish hiding subsequent tabs based on a cell value of another tab. I believe I must create all the maximum number of tabs possible and hide those that are not required? Maybe I'm going about this backwards.
Sheet 1 contains top level tasks. The user can enter 1 to 30 separate tasks, (column A6:A35). The user enters starting at row 6, then 7, then 8 etc. User will never enter row 6 then skip to row 12.
Each of those 1-30 tasks then has it's own sheet(tab). So far a maximum tab count of 31 if they enter all 30 tasks. If the user only enters 4 of the possible 30 tasks on sheet 1, I only want to display a total of 5 tabs, and hide the tabs that are not needed.
To complicate it further, each of the 4 entered tasks has it own task list of up to 50 tasks and the same thing, if they only enter 43 tasks, I only want to show the 43 tabs and hide the other 7 not including already showing the 4 of 30 tabs
Maybe this could be better described as drill down, or a drill up, I don't know anymore
. Each level drilled down to, gets potentially larger. To reverse engineer it, I have 5 to 1000 tasks which roll up into 1 to 50 tasks which roll up to 1 to 30 tasks which are listed on tab 1. How do i only display tabs that need to be shown because the task it comes from has data.
Have you guys got an ideas?
