Macro to apply a new number and then copy the result to a new table

The first part is easy, second part not quite sure about - how do you determine where the value from H4 goes?

Anyway here's the first part.

For Each dy In Range("B3", Range("B" & Rows.Count).End(xlUp)))
    Range("H3").Value = dy.Value/365

    ' this is where you need to do the second part

Next dy

Maybe:

Sub rongil20()
Dim i As Long
For i = 3 To Range("B" & Rows.Count).End(3).Row
    Cells(3, "H") = Cells(i, "B") / 365
    Cells(i, "C") = Cells(4, "H")
Next i
End Sub

Originally Posted by rongil20

Thanks John, did the job nicely

And Norie, yes I wanted thee rate in H4 to populate the corresponding cell in column C

Think I got confused when I saw the columns of data in J:L etc.

Wait a minute, do you want the value to go into the corresponding row in the Rate column where Days where taken from?