If I have a value in a1 and I want that copied to a2 only if I have a value
in d2. I tried an If statement but I ended up removing some of the data from
column a because the if statement said if d2<"",a1,""

any way to copy the formula better or would a macro work better?