Hello i hope you are well, thanks for the video is really helpfull. Could i ask for your help ? Do yo know how can i do to hidden and unhidde rows in the same way like this sheets Hide/unhidde setting ? Thanks in advance !! Best regards
This is awesome, thank you for showing hot to do this! How would I do this if I wanted to hide multiple sheets depending on a longer drop-down list. I have 4 sheets in my file: "Account Info", "Tank Request 1", "Tank Request 2", and "Tank Request 3". I want to show or hide the tabs based on the value selected in the section on the Account Info Sheet for: "Number of Tanks Needed" The options in the dop-down list in cell C45 are: None, 1 Tank, 2 Tanks, 3 Tanks If "None" is selected, I want to hide Sheets ("Tank Request 1", " Tank Request 2", and "Tank Request 3") If "1 Fuel Tank" is selected, I want to show Sheet ("Tank Request 1") and hide Sheets ("Tank Request 2" and "Tank Request 3".) If "2 Fuel Tanks" is selected, I want to show Sheets ("Tank Request 1" and "Tank Request 2") and hide Sheet ("Tank Request 3".) If "3 Fuel Tanks" is selected, I want to show Sheets ("Tank Request 1", " Tank Request 2", and "Tank Request 3".) Is that possible, or is that too many commands?
Do you have a tutorial on creating a drop down list that will change the entire worksheet? I have a schedule I create every month and I have 12 sheets for each month. Is there a way to have a drop down that will change the data ("select data") but keep all other formatting etc the same?
I would love to be able to find a multilevel code that not only renames certain sheets based off a list within my dashboard, if the value isn't present in the sheet I want it conditionally formatted that if lets say the cell value isn't present it hides the sheet. I have a dashboard sheet that has 14 account numbers & I need to be able to adapt the 14 sheets based on a list if there are 12 account numbers it will hide the sheet and rename it "Blank sheet" however if in the cell here is a value it unhides the sheet can you help me ?
All of your demonstrations are super helpful - Tks for posting them.
Glad you like them!
Hello i hope you are well, thanks for the video is really helpfull.
Could i ask for your help ?
Do yo know how can i do to hidden and unhidde rows in the same way like this sheets Hide/unhidde setting ?
Thanks in advance !!
Best regards
This is awesome, thank you for showing hot to do this!
How would I do this if I wanted to hide multiple sheets depending on a longer drop-down list.
I have 4 sheets in my file: "Account Info", "Tank Request 1", "Tank Request 2", and "Tank Request 3".
I want to show or hide the tabs based on the value selected in the section on the Account Info Sheet for: "Number of Tanks Needed"
The options in the dop-down list in cell C45 are: None, 1 Tank, 2 Tanks, 3 Tanks
If "None" is selected, I want to hide Sheets ("Tank Request 1", " Tank Request 2", and "Tank Request 3")
If "1 Fuel Tank" is selected, I want to show Sheet ("Tank Request 1") and hide Sheets ("Tank Request 2" and "Tank Request 3".)
If "2 Fuel Tanks" is selected, I want to show Sheets ("Tank Request 1" and "Tank Request 2") and hide Sheet ("Tank Request 3".)
If "3 Fuel Tanks" is selected, I want to show Sheets ("Tank Request 1", " Tank Request 2", and "Tank Request 3".)
Is that possible, or is that too many commands?
Do you have a tutorial on creating a drop down list that will change the entire worksheet? I have a schedule I create every month and I have 12 sheets for each month. Is there a way to have a drop down that will change the data ("select data") but keep all other formatting etc the same?
That's a great idea! Send me details over email and i'll take a look. Email address is in the channel about section.
I would love to be able to find a multilevel code that not only renames certain sheets based off a list within my dashboard, if the value isn't present in the sheet I want it conditionally formatted that if lets say the cell value isn't present it hides the sheet.
I have a dashboard sheet that has 14 account numbers & I need to be able to adapt the 14 sheets based on a list if there are 12 account numbers it will hide the sheet and rename it "Blank sheet" however if in the cell here is a value it unhides the sheet can you help me ?