hi
in m2 enter...
=if(A1="","",A2)

regards
FSt1

"Derek" wrote:

I want to copy data from one cell to another, but only if a 3rd cell has data
example
M3=A2(if A1 has data)

do i need a macro for this