Thanks Mofi! Absolutely WONDERFUL! I don't yet understand it, but it's WONDERFUL!!
I am a little embarrassed to ask the forum for more help on this macro - I have been reading up on macros to try to get up to speed, but I am having a tough time finding the pieces I need to understand to do what I want to do...
After the macro runs, I will end up with something like this:
bbcdefg:hijk,THEWORD THEWORD THEWORD
qweqwe:qwer, THEWORD THEWORD
What I REALLY need (which I have tried to do manually AFTER running this amazing macro) is a result that looks like this:
With large files, I have found how "human" I am in making errors as I am copying and pasting and typing... trying to get the above result.
I spent some time looking over posts having to do with duplicate values and duplicate lines hoping to get a clue (most posts had to do with deleting) - but this is still way beyond me... so all help is appreciated
The rest I can do manually if need be, but if anyone insists on helping me even further...
I need the file sorted with some more slicing and dicing for THIS final result:
Mofi - your macro alone has saved me a tremendous amount of time - even if someone does not help me further, I am still way ahead here. Thanks to all for your posts.
And what an amazing product!