Maybe just put this in O14:
=BM4
or
=if(bm4="","",bm4)
crabtrees wrote:
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 a
function so that I do not have to run the macro to get the value copied
from BM4 to O14.
I appreciate your help in advance.
--
crabtrees
------------------------------------------------------------------------
crabtrees's Profile: http://www.excelforum.com/member.php...o&userid=37611
View this thread: http://www.excelforum.com/showthread...hreadid=572779
--
Dave Peterson