Hi,
I've got an Excel document with over 323 entries and I need to search the data to find where ever a certain keyword is mentioned and copy the entire row into a separate sheet within the same workbook. However, I have a list of around 323 keywords and there is AND condition as well.so doing this using Ctrl+F would take some time.
The data is in Sheet “Training Dataset” and the particular column that needs to be searched is Column "A" . “Training Dataset” is the sheet where I would like the found results to be copied to in the column B and C. The list of Keywords that need to be searched for are located in Sheet “Keywords” , starting from Cell C and D.
I am enclosing a sheet for your perusal.
P.S: unable to add the file to the thread... what might have gone wrong?
Does anyone think they can help me create a macro to carry out this task or know of a better solution for doing it?
Any help would be much appreciated.
Thanks,
Kiran