|Hello all and thanks for taking the time to help.|
I am trying to build a macro button that will when clicked:
1. Insert a new row at a specific point (say under row 20),
2. Copy values from cells B4,B5,B6,B7 etz to the new row (B4 to A20, B5 to B20, B5 to C20, etz)
3. Clear the values from cells B4,B5,B6 etz.
I have been able to find/build the first and 3rd part but cannot seem to combine it with the With .Copy code i am using for the second.
Regards, and thanks again for the help