Copy paste + Remove

[Flammabubble]

Hi guys,

So I'm having an issue working out how to use VBA to copy, paste and clear cells in the same module. What I have currently is a button that will copy cells b10:k10 from Sheet 1 to Sheet 2.

What I need it to do is when pressed copy B10:K10 from sheet 1 to sheet 2, then copy b2:k2 on sheet 2 to sheet 3 and remove b3:k7 on sheet 2.

I have been able to make it copy from sheet 2 to sheet 3, but it then will not clear sheet 2 using .clearcontents so I'm unsure what I'm missing.

[6StringJazzer]

Please show all your code here, or attach your file. It is impossible to answer this question without seeing your code.

[Flammabubble]

Sorry, code may be convoluted, but currently I have the below. If anyone has suggestions to shorten it then I'm open to that as well.

Please Login or Register  to view this content.

What is remaining is to get it to clear "Daily Totals" Range B3:K7 after procedure 12 has completed.

[6StringJazzer]

Based strictly on your description the code you want is

Please Login or Register  to view this content.

I have also rewritten your code to be a bit more streamlined. I gave it only a cursory test because I do not have your file.

Your description says, "copy B10:K10 from sheet 1 to sheet 2" but that is not what your code does. Your code copies B10 and K10, but not the entire range B10:K10.

Also, some items are copied from row 10, others from row 16. I assume you did that on purpose, but maybe not.

Please Login or Register  to view this content.