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.
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
ExcelVBA-Find a listed Keyword & move entire string to the Sheet