- Hot Topics
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 5, 2009.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel