Create a Macro from this simple search function

HELP!!! I suck at this.
I am using excel 2007 for database of a large e-commerce site.
I am creating search-able attributes from keywords found in description, title and meta-data columns.

I am using the following function in "column X" to search 4 columns (see formula) for specific music styles.

=IF(SUMPRODUCT(--(ISNUMBER(SEARCH(" Rock ",A2:C2:D2:F2:H2)))),"Rock","")

I have hundred of searches to do and this formula works but is extremely time consuming.


It would be cool if I could search for multiple criteria simultaneously and have the columns created if a "true value" is returned.
i.e Search columns A - C - D - F - H for all music style terms and output the "true - value" to separate columns. Which I will combine later.

• Search for "Rock" (output to column X)
• search for "jazz" (output "true" to column Y)
• search for "Classical" (output "true" to column Z)
• And So on

Creating the columns via the macro is not essential, if I must first create the empty columns and make sure the macro outputs correctly, so be it.

I don't know much about macros but from what I have read it seems like the way to go. I would then be able to use the maco's and create a template and use them for each csv file I receive from different publishing companies.

Any suggestions would be extremely appreciated,
McMasters

sheet 1 contains relevant database info and the functions I am currently using.
Sheet 2 contains a non ordered list of search criteria that I will be using in the macro.