Hi,
I've got an Excel document with over 7K 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 50 keywords so doing this using Ctrl+F would take some time. I'm new to Macros but I think that a macro may be the best solution for this task.
The data is in Sheet1 and the particular column that needs to be searched is "K". The contents of column "K" is made up of words and sentences. Sheet2 is where I would like the found results to be copied to. The list of Keywords that need to be searched for are located in Sheet3, starting from Cell A1. Below is a list of the sort of words that need to be searched for:
Jaguar
Landrover
Tata Motors
Volvo
Audi
Mazda
Vauxhall
Opel
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,
Bookmarks