how to cut certain range that is not empty to another sheet?

[Step01]

how can i move the range that is (C:AL) row to another sheet if the range cell is not empty.

Thanks


for example when my range "A" until range "CL" is not empty then it will move the range a row to another sheet with vba.

[davesexcel]

Can you clarify your question.

[Step01]

i had updated with the question such as added example explain.

thanks

[AliGW]

Your example doesn't make sense. What does this mean?

for example when my range "A" until range "CL" is not empty then it will move the range a row to another sheet with vba.

What is "it?"

What does "move the range a row" actually look like in practice?

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

[Step01]

"it" mean clicked micros

"move the range a row" mean will move the 1 "A:CL" range to anohter sheet.

Thanks!!

[AliGW]

See post #5.