Copy Paste Cell Text

Hello!
I am looking at column E. "_Notes" is the only text in column E.

If other text is found in columns to the right of E, that text needs to be copied to the next row down.

Hi Tortus,

What if there is already text in "the next row down? Do you want to copy over it? Do you want the answer to overwrite other text that is already there? In a VBA solution I'd use For Next loop and start from the bottom and work to the top.

Overwrite what is already there for this exercise. Thanks!

"looking down a long empty hallway" Hello!

Hey Tortus,

This feels a lot like a homework assignment.... I'm west of you so I just got my second cup or joe. Good that you post today as that puts your question up on the stack and I can find it. I'll get right to your problem.

OK - 2 cups of coffee and my VBA skills seem to work... Here is the code.

Please Login or Register  to view this content.

I'm pretty old and like the Cells(r,c) notation because I can put quotes around the column letter.
I also like to name my variables with meaningful names instead of i,j,k so I know what they are down in the code. I wish other programmers would do this too.
Some others like to use For Each type of loop but I'm old and like row and column NUMBERS instead.

Good luck on your assignment.

Thanks, let me give it a try and I'll get right back with you. Hopefully you are safe from that virus stuff. Hot coffee should kill it!

Works great, thank you very much! Stay safe and healthy!