Hi there, I'm having trouble figuring this one out, I'd like to include this code in a macro that sorts some information out for me, but for the life of me can't find a code that will just select a column on the left/right without putting the exact cell name, which is not what I want.
Here's basically what I'm trying to do:
If Cell range KO contains the word "How" then copy cell to the right (KP) and paste to column KQ in the same row.
The excel sheet I will have will have hundreds of varying text, so it needs to just select the column on the right and then paste the text to the next cell on the right, I can't code it to know the cell it will go into which is where I'm lost.
I've added a photo to make this more clear, as I'm not sure if I've explained this very well, most appreciated in advance anyone that can help me out!
exceleeeeeeeeeee.PNG
excel2.PNG
Bookmarks