Hello, Sorry if this has been asked before but I am truly a newbie to this and cannot figure this out. I am self taught through searching and YouTube videos. Thank you for any assistance you can provide.
I have already used a code to hide/unhide tabs based off a specific cell value but now I need to hide/unhide rows based off that same cell value across multiple worksheets.
Cell "STORE" on worksheet 1 is "NO" it will hide worksheet 7. If "YES" it will show worksheet 7. This code is entered in on worksheet 1. Now I need a code for Cell "STORE" on worksheet 1 is "NO" to hide/unhide rows 22:23, 27-35, 39 on worksheet 3; 3-17 on worksheet 4; and so on. I will also need to be able to add additional cell values to have the code look at and hide/unhide additional rows in the same worksheets.
I have already used a code to hide/unhide tabs based off a specific cell value but now I need to hide/unhide rows based off that same cell value across multiple worksheets.
Cell "STORE" on worksheet 1 is "NO" it will hide worksheet 7. If "YES" it will show worksheet 7. This code is entered in on worksheet 1. Now I need a code for Cell "STORE" on worksheet 1 is "NO" to hide/unhide rows 22:23, 27-35, 39 on worksheet 3; 3-17 on worksheet 4; and so on. I will also need to be able to add additional cell values to have the code look at and hide/unhide additional rows in the same worksheets.