ExcelVBA-Find a listed Keyword & move entire string to the Sheet [Closed]

Report
Posts
14
Registration date
Tuesday October 30, 2012
Status
Member
Last seen
January 5, 2017
-
Hello and greetings CCM Expert team.

May I request you to kindly help me with the following request:

1. Looking-up a Keyword [one-by-one] from a predefined list of words from a column in a sheet and move the entire string that contains this/these words in the Predefined <Sheet/Sheets>.

2. When the First word is found, then the entire string [between two Period Signs] should be moved to the sheet that matches to the Sheet with same Name.

For Example:
Condition 1 - If there is a text, ". Ajay & Vijay are good boys.", and we have a keyword and a Sheet named as <Good>, then this string "Ajay & Vijay are good boys". should move to the cell A1 of the Sheet

Condition 2 - If there is a text, ". Ajay & Vijay are good boys.", and we have a keyword and a Sheet named as <Boys>, then this string "Ajay & Vijay are good boys". should also move to the cell A1 of the Sheet

That would be fine, if there is a manual work to create sheets, in advance [based on listed key words prior to executing the macro].

The help and assistance on this request would be highly appreciated.

Kind and sincere regards - Ajay Dwivedi

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!