Thanks again for all your hard work, I'm still using the old codes but I will be sure to add this to the sheet. However I have managed to break a good thing and I'm sorry. All I did was add a column prior to the part # column. Now I knew that this would require me to change all VBA coding and increment the number to "6" from 5 because now it is in column "F" and no longer "E". I changed that on both the failed page and the initiating devices page however I no longer can get it to copy things correctly. When choosing "FAIL" it now seems to copy information from random areas, I can't even figure where its getting it from. I thought that I did everything right. I will try and put your NEW code with the array in it as I like the way it works much better and its easy to add and subtract words from it.

What did I do wrong.

Here is the list of changes from prev. version

portrait changed to landscape both pages
dependent dropdown list for column "E" "part # and column "D" Manufactuer
Countif added to several other columns to count keywords and display a number on executive summary page.

Sorry to break such a good thing, I got the other codes to work so I must be missing something.

Thanks
excel grrrrrrrrr