Cut and Paste Macro

[Legacy 436357]

Hi is there a code that will cut and paste in a range if cell D is not blank and paste in cell B?

Thank you

 

[Legacy 436357]

Can it be done with a formula?

Column C and D get filled when column L is "TRUE". Perhaps a helper column?

=IF(C2<>"",A2=P2,"")

It puts FALSE in cell P2. I know this is wrong.

 

[alansidman]

Can't have a value and a formula in the same cell. One or the other. If A and B are already populated with a value, you cannot put a formula in cells A and B.

 

[Legacy 436357]

I am trying to understand sorry for my ignorance.

 

[Legacy 436357]

I ran the code and it replaced the date and number but it also cleared column A and B in the other rows. I did not want them cleared.

Can it check for blanks in column C and D and do nothing in those rows?

 

[Legacy 436357]

I was able to alter my formulas to accomplish this thanks for the help.