Search for the keyword with and condition and return to the different sheet within excel

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

You forgot to enclose sheet..
kiran..


Don't forget to click *

I am trying to attach the file... but attach manage tool is not showing my file after I add files... any workaround here

It doesn't upload a file great than 1000 kbs

if that is not the problem..
try uploading the file first...
then close the window and ....
then click the manage attachment..again..
it will show up then..

Don't forget to click *

Here is the attachment....

check the solution..


Don't forget to click *

Hi Vikas

Thanks for the file... We have millions of data that needs to be processed.... Hence formulae would take time in the excel to process...
Can we make it to a macro so that it can run with a click of a button

Thank you

Regards
Kiran Kumar

Okay..
I am making it..
wait for my reply..



Vikas Gautam


Don't forget to Click *

Got the solution...

here is the code..

Please Login or Register  to view this content.

Change your code range manually in the code..


Don't forget to click *

Here is the attached file..

Don't forget to click *, again..

Hi Vikas,

Thanks for the macro.... this is what I am exactly looking for... the macro worked excellently

Regards,
Kiran Kumar

Its my pleasure
Kiran...