How to Automatically Hide Rows based on Cell Value - Sheet Protected and Formula Hidden скачать в хорошем качестве

How to Automatically Hide Rows based on Cell Value - Sheet Protected and Formula Hidden

Want to learn how to design a salary structure? Check: https://www.caripros.com/design-salar... FREE template for my video: Excel for HR - Create Annual Employee Salary Increase Template from Scratch. You can download and try it out yourself here: https://bit.ly/2MLLdb7 FREE actual workbook for my video "Split a Master Spreadsheet into Multiple Sheets with 1 click - VBA for Beginner". You can download and try it out yourself here: https://bit.ly/2UmeX2v New course Launched! I created it to show you step-by-step how to design a salary structure with regression analysis in Excel. Check out the detail here: https://caripros-hr-analytics.teachab... Topic: Excel Macro - How to Automatically Hide Rows based on Cell Value Scenario: You want to automatically hide rows/content when you select certain value in a specified cell Function: Macro Related Videos: How to Automatically Hide Rows based on Cell Value - Formula-driven and Multiple Criteria http://bit.ly/2ATnfov How to Automatically Hide Rows based on Formula driven Cell Value http://bit.ly/2nENfjX How to Automatically Hide Rows based on Cell Value http://bit.ly/2orQvQ7 How to Automatically Hide Columns based on Cell Value:    • How to Automatically Hide Columns based on...   Automatically Hide Nonsequential Rows based on Cell Value: http://bit.ly/2nthkmN **Macro Code** Private Sub Worksheet_Calculate() Dim Country, Location As Range Set Country = Range("C5") Set Location = Range("C7") 'sheet is now protected ActiveSheet.Unprotect Password = "12345" Select Case Country Case Is = "Canada": Rows("21:35").EntireRow.Hidden = True 'both India ranges are hidden Rows("9:20").EntireRow.Hidden = False 'Canada range is shown Case Is = "India": Rows("9:20").EntireRow.Hidden = True 'Canada range is hidden Rows("21:35").EntireRow.Hidden = False 'both India ranges are shown End Select Select Case Location Case Is = "Mumbai" Rows("9:20").EntireRow.Hidden = True 'Canada range is hidden Rows("21:27").EntireRow.Hidden = False 'Mumbai range is shown Rows("29:35").EntireRow.Hidden = True 'non-Mumbai location range is hidden Case Is = "Non-Mumbai Location" Rows("9:20").EntireRow.Hidden = True ' Canada range is hidden Rows("21:27").EntireRow.Hidden = True 'Mumbai range is hidden Rows("29:35").EntireRow.Hidden = False 'non-Mumbai location range is shown End Select ActiveSheet.Protect Password = "12345" End Sub *****Follow-up Consulting Services***** If you have specific question regarding your issue, you can email me at the email here https://goo.gl/WejijZ Note that there will be a fee of US$200 charged for solving your issue. The turnaround is within 24 hours. Any follow-up issue in 3 days will also be answered with no charge. Payment link: https://www.paypal.me/caripros *****More Videos in Playlists***** Power BI for Beginners: https://bit.ly/3ivKitD Power BI for Advanced Users: http://bit.ly/3lE9zmO Excel for HR https://goo.gl/JdeVnd Excel for HR - Master Class https://goo.gl/LYfq2f Excel Macro - Beginner https://goo.gl/Yae5nc Excel Macro/VBA - Splitting a Master File https://goo.gl/m8CHya Excel Macro/VBA - Auto-hide Rows or Columns http://bit.ly/2Mzteb5 Excel Charts Data Visualization https://goo.gl/2ao6BP Excel Vlookup Function https://goo.gl/kP2Wpz Excel Pivot Table Function https://goo.gl/rukkPs Excel Array Function https://goo.gl/i4sQH8 Excel Index and Match Function https://goo.gl/i7VGU4 Excel Solver/Goal Seek Functions https://goo.gl/FTkTnj Excel Cell Formatting Solutions https://goo.gl/gpa6MY HR Analytics - Merit Matrix https://goo.gl/Koy7co HR Analytics - Salary Structure https://goo.gl/uZBnFa Excel Tricks https://goo.gl/TeqGDw Excel Troubleshooting https://goo.gl/bdY5by Fun HR Topics https://goo.gl/7zVg8h For more successful stories, view at: http://caripros.com/index.php/success... #ExcelforHR#HRAnalytics#Excel#HR