• Great ... :)


    So will start from this base to remove all merged cells ...


    Should you want to have your Italics macro included in the Version 4 ... please post it with your next message ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Attached is your Version 4 ... without merged cells ... :)


    For your visual alignment, have used Center Across Selection ...


    Hope this will help

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Here is the macro.


    Function SumItalics(rSumRange As Range)

    Dim rCell As Range

    Dim vResult


    For Each rCell In rSumRange

    If rCell.Font.Italic Then

    vResult = WorksheetFunction.Sum(rCell) + vResult

    End If

    Next rCell


    SumItalics = vResult

    End Function

  • Thanks for the macro


    How do you need to use this UDF ...?


    Thanks for describing how you want to apply it ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello,


    Have you had a chance to take a look at Version 4 ...?


    Is it in line with your expectations ...?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi again,


    Attached is your Version 5 ... with some cleaning ... no merged cell ...

    Main suggestion is to move Data on its own tab and keep them separate from your Recap of your 17 Hires ...


    Hope this will help

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)