Transfer Cell Value

[crabtrees]

I'm currently using a macro:

Sub copyvalue()
With Sheets("Capacity")
.Range("O14").Value = .Range("BM4").Value
End With

End Sub

But I'm very interested in getting any help to upgrade this to
function so that I do not have to run the macro to get the value copie
from BM4 to O14.

I appreciate your help in advance

 

[Dave Peterson]

Maybe just put this in O14:

=BM4
or
=if(bm4="","",bm4)