Tanner_2004
Well-known Member
- Joined
- Jun 1, 2010
- Messages
- 616
I would like a macro to search a column (F2 down to the end), find a collections of strings that I will hard code into the macro and covert the strings to another string and paste them next to association string in another column.
If we start with D2 and search down for R.N, R.N. VA, and RN CA (these are the values that I would hard code), ask the macro to deposit RN 1 cell to the right of the hard coded string.
I would like to do the same for OR Tech, OR Tech UK, OR Tech GA by coverting and copying the result (in this case OR Tech) to the cel to the right of the original string.
I was hoping to have the macro allow me to concert and paste all of the similiarty title strings into one string.
So within the same macro, If ABC, YTR, THE then RN; If MNB, OIU, POU, then OR Tech; if GHY, KLJ, BVC, then PT. But I want to preserve the original value.
If we start with D2 and search down for R.N, R.N. VA, and RN CA (these are the values that I would hard code), ask the macro to deposit RN 1 cell to the right of the hard coded string.
I would like to do the same for OR Tech, OR Tech UK, OR Tech GA by coverting and copying the result (in this case OR Tech) to the cel to the right of the original string.
I was hoping to have the macro allow me to concert and paste all of the similiarty title strings into one string.
So within the same macro, If ABC, YTR, THE then RN; If MNB, OIU, POU, then OR Tech; if GHY, KLJ, BVC, then PT. But I want to preserve the original value.
