Automatically delete row after cut and paste

[PCloadletter]

Hello,

In Excel 2016, Is there a way to automatically delete a blank row after you cut and paste data to another worksheet?

My situation is this :

In our workbook we have one tab of data of active persons. Another tab is for cancellations.

When someone cancels out, we cut and paste from the active tab to the cancelled tab

If there are multiple cancellations, it leaves behind multiple blank rows which is tedious to go back to remove and sometimes is not done.

Can the blank row be automatically “moved up”?

Thank you.

 

[sdennant]

is there a way to do a similar thing but copy multiple specific cells? for instance, let's say i wanted rw1, to copy only cell, b, c, d and H, and past to another sheet? because i can only see how to do ranges as opposed to individual cells.

 

[Joe4]

is there a way to do a similar thing but copy multiple specific cells? for instance, let's say i wanted rw1, to copy only cell, b, c, d and H, and past to another sheet? because i can only see how to do ranges as opposed to individual cells.

How many columns are there in total?
Are you wanting to copy it to the same column references on the new sheet (copy b to b, c to c, etc)?
Are you then wanting to delete the WHOLE row from the original range (like in the original question) after the copy?

 

[sdennant]

Sheet one has 17 columns through to Q.
Sheet two has 20 columns through to T

not exactly:

Sheet 1 (Sainsbury's) i want to copy just B, C, D, F, H, J, K, M
Paste into Sheet 2 ( All Orders)
- B is pasted into D
- C is pasted into E
- D is pasted into G
- H is pasted into F
- F is pasted into J
- J is pasted into I
- K is pasted into L
- M is pasted into P

i dont want to delete them from the source sheet. just copy.
i also have formulas in sheet two which i dont want the paste to overwrite. i want the past to work with the formulas so the formulas continue to do their job in sheet 2.

i hope that makes sense. confused me writing it.

images below.

 

[Joe4]

OK, this question is significantly different than the original question that was asked in this thread.

The general rule of thumb is that you should only post to old threads that aren't yours if your question is pretty much exactly the same as the original question, or if you are just looking for clarification on one of the replies made in the thread.

Otherwise, it is almost always better to post your question to a brand new thread, so that it shows up on the "Unanswered threads" listing that most people use to look for new unanswered questions that need assistance. It will get more "looks" that way, and stand a better chance of getting a solution.

So I recommend posting your question to its own, new thread. You can post a links back to any posts if you think it would be helpful to the person looking at answering the question.

 

[sdennant]

okay, i'll post anew.

my bad. thanks for your help.

 

[Joe4]

my bad. thanks for your help.

No worries. I see that you are fairly new here, so just trying to give you some tips to maximize your chances of getting your issue solved.

 

[sdennant]

i am indeed. pasted the thread here: VBA - Copy and Paste from one sheet to another based on drop down criteria

this forum helped me before so hopefully again.

 

[sdennant]

Btw. Did you have any ideas. No one seems to have replied to my new thread

 

[Joe4]

I would have to play around with it, but it definitely would be a bit more complicated and take more time to do, and I don't have that kind of time at the moment.