Excel: Find Value in cell via Inputbox, copy row, paste in new worksheet

Hello Everyone, I have been trying to write a macro in VB that will search for a word in a cell, the word would be input by the user via a inputbox, search the entire worksheet, then copy the entire row the word is found on, and paste the row into a new worksheet that is part of the same workbook. I am not attaching the code I have been working on because it is awful and I think I have been going about this in the wrong way. Any help is greatly appreciated. Thanks in advance.

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of August 05, 2009.

For more resources for Microsoft Excel