Want to learn how to design a salary structure? Check: 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: 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: 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: Topic: How to create a Solver with Excel VBA for data modelling Business Scenario: When planning for salary increase, you need to create a merit matrix that allows you to spend your merit increase and incentive budget that satisfies your criteria Formula: Solver, Macro Using Solver with VBA: Solver OK Function: Solver Add Function: ***Macro Code*** Sub SingleSolver() SolverOk SetCell:="$L$13", MaxMinVal:=2, ByChange:="$J$7,$G$11" SolverAdd CellRef:="$G$11", Relation:=3, FormulaText:="2%" SolverAdd CellRef:="$J$7", Relation:=3, FormulaText:="3%" SolverSolve End Sub For more successful stories, view at: ******Follow-up Consulting Services****** If you have specific question regarding your issue, you can email me at the email here 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: ******More Videos in Playlists****** Power BI for Beginners: Power BI for Advanced Users: Excel for HR Excel for HR - Master Class Excel Macro - Beginner Excel Macro/VBA - Splitting a Master File Excel Macro/VBA - Auto-hide Rows or Columns Excel Charts Data Visualization Excel Vlookup Function Excel Pivot Table Function Excel Array Function Excel Index and Match Function Excel Solver/Goal Seek Functions Excel Cell Formatting Solutions HR Analytics - Merit Matrix HR Analytics - Salary Structure Excel Tricks Excel Troubleshooting Fun HR Topics For more successful stories, view at: #ExcelforHR#HRAnalytics#Excel#HR