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.
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.
Last edited by Tortus; 03-11-2020 at 02:32 PM.
If we all use our Minds our Heads and our Brains NO TELLING what we could come up with!!
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.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
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.
I'm pretty old and like the Cells(r,c) notation because I can put quotes around the column letter.Please Login or Register to view this content.
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks