I need help with a macro. I want to do a search for a particular word in a certain column, then if the previous column is blank, copy and paste it.
This example, if column C contains the word dog anywhere AND column B cell preceding it is blank, copy and paste the cell into the previous column. If column B contains any info, do nothing.
The dashes are BLANK spaces to keep the columns matched up
Start With:
A ---- B ---- C
Test -------- The Dog is happy
Test - Five - The dog has a bone
Test -------- The cat is sad
Changes to:
A ---- B ----------------- C
Test - The Dog is happy -- The Dog is happy
Test - Five --------------- The dog has a bone
Test ---------------------- The cat is sad
Bookmarks