Here is what I am trying to do. I am not sure how to write this macro.

Given:

Table1.xls
Contains a table on sheet2 A1:F1000.
(Ex. A1 = 456325 B1 = this is a website C1 = the name of the file is 1003_3.14.aspx)

Criteria.xls
Contains a list of text that I am searching for (A1:P1)
(Ex. A1 = 1003_3)

Results.xls
Blank

Goals:

1. find cell A1 on Criteria.xls and create a new sheet on Results.xls with that name. (Ex - Criteria.xls, A1 = 1003_3 then new sheet on Results.xls is called 1003_3)

2. find cell A1 on Criteria.xls and searches for ALL fields that contain that word in Work in Table1.xls, sheet2, range A1:F1000. (IMPORTANT - if my search criteria is 1003_3 and it finds that inside a "word" such as 1003_3.14.aspx then that should be accepted as a result.)

2. When it finds any combination of , Criteria.xls cell A1, on sheet2 of Table1.xls it copies the entire row from sheet2 on Table1.xls to the sheet created in Results.xls (sheet 1003_3) and continues to copy row after row until it has reached the end of the table (A1:F1000) on Table1.xls sheet2.

3. Then it restarts the entire process with the next line down (cell B1 on Criteria.xls; makes a new sheet named as the search criteria, and searches for the criteria as before) This continues until it reaches the end of the list on Criteria.xls

I have no idea where to start here...any suggestions?