Showing 'latest' months data in a summary | Excel forum

Hi Sheila

To assist with your requirement will most likely involve some didicated time with a relevant trainer having access to your spreadsheet.

Naturally this will be consultative work and therefore billable.
If you wish to discuss this in more detail please do let us know.

Regards

Jacob

Hi Sheila

Thank you for your question

I have created a custom function in VBA which solves your problem. To install it:

1. Press ALT_F11 to open VBE
2. Create a new module by clicking on the second betton from the left on the toolbar and choose "module".
3. Then copy and paste the following code into the code window (Large window on right hand side)

Function LastValue(VarRange As Range) As Single



    Dim i As Integer

    Dim intTemp As Single



   

        For i = 1 To VarRange.Columns.Count

        

            If VarRange.Cells(1, i).Value = 0 Then

            

                LastValue = intTemp

                Exit Function

                

                

            Else

            

                intTemp = VarRange.Cells(1, i).Value

                LastValue = intTemp

                

             End If

         

        Next i   

    





End Function