Hello,
Need macros to search certain word (in example "client") in the column and copy to the next column searched word together with following 2 words. Words are separated by space:
mr dear client tomi mayo kaun
esti client mako res tuva exco
ambe acco gir client ingo tes
Result should be:
client tomi mayo
client mako res
client ingo tes
Thanks.
sausis,
Welcome to the forum! Does it have to be VBA?
Attached is an example workbook based on the criteria you described.
In cell B1 is where you type the word to search for, in this case "client"
Starting in cell A4 and down are the original text strings
In cell B4 and copied down is this formula:
Please Login or Register to view this content.
That formula provides the correct results. Does that work for you?
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you Tigeravatar,
I understand that formula is simplier, but in this case I need vba (it is only part of task).
Sausis
sausis,
Here's a VBA version
Please Login or Register to view this content.
Condensed version:
Please Login or Register to view this content.
Perfect!
Thank you Tigeravatar.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks