Auto Fill even spaced numbers between two set numbers

Hi and welcome to the forum!

Highlight the range C9:C15. Go to Home/Fill/Series. Excel should be able to detect what you wish to do (you should see a Step value of 2.16666666666667, etc.). Just press OK.

Format cells with desired number of decimal places.

Regards

Try This
14
=C10+($C$15-$C$10)/6
=C11+($C$15-$C$10)/6
=C12+($C$15-$C$10)/6
=C13+($C$15-$C$10)/6
27

Can you post a sample workbook so we can see precisely how your data is laid out? It doesn't have to be your actual data - a mocked-up version with dummy data will do, just so long as it illustrates what you are trying to achieve.

Regards

    Dim A1 As Range, B1 As Range, c1 As Range, Rng As Range, cnt As Integer, x, s1, s2, y, t1, t2, z

    Set Rng = Columns("A:A").SpecialCells(xlCellTypeConstants, 23)
    cnt = Rng.Count
    For x = 1 To cnt / 2
        Set A1 = Range("A1")
        Set B1 = A1.End(xlDown)
        Set c1 = B1.End(xlDown)

        t1 = B1 - A1
        t2 = B1.Row - A1.Row
        z = t1 / t2

        s1 = c1 - B1
        s2 = c1.Row - B1.Row
        y = s1 / s2
        If Range("A2") = "" Then
            Range(A1, B1).DataSeries Rowcol:=xlColumns, Type:=xlLinear, Date:=xlDay, _
                                     Step:=z, Trend:=False
        Else: Range(B1, c1).DataSeries Rowcol:=xlColumns, Type:=xlLinear, Date:=xlDay _
                                     , Step:=(y), Trend:=False

        End If
    Next x

See attached to see it in action

Not sure what that means.

Did it work for you?

Yep, just change the columns.