Hello,
I am unsure if I would even need VBA to do this. I am trying to find a way to highlight all cells in column AO that have duplicate phrases and transfer just the phrase over to column CF. Ex: A cell containing "She didn't listen" and a cell containing "They didn't listen" would highlight and "didn't listen" would move over to Column CF. Would it be possible to do this without specifying the exact phrase?
Last edited by daneff; 03-13-2014 at 11:35 AM.
Anybody happen to know if this is possible? I'm not really sure this is possible. Actually if it could just copy the phrase over to column CF, it wouldn't need to highlight.
I believe that no one can say something for sure in Excel.
As an opinion(same as the other 80 people that seen your thread) this that you describe can not be done.
I hope to be wrong on this.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
No response does not mean that it can not be done. It probably just means that it would take an extensive effort to do. I would not even consider doing such a thing without using code.
Each cell has to be compared to every other cell. The complexity increases with the number of words in each cell and the number of cells. To compute the comparisons needed, use permutations.
If the problem can be better defined and not as involved as I suspect, you might get a solution. Posting an example workbook with a before and after sheet helps those that help you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks