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
--
crabtree
-----------------------------------------------------------------------
crabtrees's Profile:
http://www.excelforum.com/member.php...fo&userid=3761
View this thread:
http://www.excelforum.com/showthread.php?threadid=57277