Copy Data from one cell to another cell

Okay.. you can simply use below formula:-

Formula:

=IF(TEXT(TODAY(),"mmmm")=A1,'Asset Table'!$F$51,"")

see attachment: Asset Manager.xlsm



Regards,
DILIPandey
<click on below * if this helps>