Want to learn how to design a salary structure? Check: https://www.caripros.com/design-salary-structure-with-regression-analysis-upgraded-with-case-study
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.teachable.com/p/design-salary-structure-with-regression-analysis Topic: Excel Macro – Sum all total numbers in all tabs with different row count
Scenario: You want to sum the Base Salary in all rows in each tab. Each tab may have different row count
Function: Loop, Range().End(xlDown), =Sum(‘*/”!H4)

***Macro Code***
Sub SumValueAcrossTabs()
Dim i As Integer
Dim ws_num As Integer
Dim ws As Worksheet
Dim SumRg As Range
ws_num = ThisWorkbook.Worksheets.Count

For i = 1 To ws_num
ThisWorkbook.Worksheets(i).Activate
Set SumRg = ActiveSheet.Range(/”H6/

Please take the opportunity to connect and share this video with your friends and family if you find it useful.