Hi. I would like to perform the following repetitive task through macro.
Formula in H1: =CONCATENATE(B2,": ",C2)


I would need a macro that pastes the value of H1 to B2, then delete C2.
When I change the cell references from B2 to B7 and C2 to C7, the macro pastes the result in B7, then delete the value in C7.
I tried recording the steps but the range was stuck at B2 and C2.
Thank you.

Attached Files

Copy value of formula.xlsx (9.0 KB, 11 views)