I am a novice and looking for a VBA code to copy all sentences of matching string based on the given keys that match up to five characters in the output sheet (as below). My actual data is a few thousand rows long and is in the sheet named "string". My key data is a few hundred and is in the next sheet named output.
HTML:
Excel 2010AB1sl notext21A Theapple and ornage got ID &*(. graps are fine but they are not sweet. 2graps are better. What about ange*l1 of jordan.
The colo of triology is fine. +++colony is named after him. When aJOHN2ofswiss said this ?32A Theapple and ornage got ID &*(. graps are fine but they are not sweet. 2graps are better. What about ange*l1 of jordan.
The colo of triology is fine. +++colony is named after him.When aJOHN2ofswiss said this ?43A Theapple and ornage got ID &*(. graps are fine but they are not sweet. 2graps are better. What about ange*l1 of jordan.
The colo of triology is fine. +++colony is named after him. When aJOHN2ofswiss said this ?[CENTER][COLOR=#161120][B]string[/B][/COLOR][/CENTER]
Excel 2010AB1keyoutput2apple1 &*( orangeA Theapple and ornage got ID &*(.3orange* graps1graps are fine but they are not sweet. 2graps are better. What about ange*l1 of jordan.4#colony21 triologyThe colo of triology is fine. +++colony is named after him.5*john21+When aJOHN2ofswiss said this ?6*joh17*joh28*joh39*joh410*joh511*joh612*joh713*joh814*joh915*joh1016*joh1117*joh1218*joh1319*joh1420*joh1521*joh1622*joh17[CENTER][COLOR=#161120][B]output[/B][/COLOR][/CENTER]
