Share this page:  MS Excel: Enter a value in an InputBox and
then search for this value in a column and copy row to new sheet
for all matching values in Excel 2003/XP/2000/97  Question: In
Microsoft Excel 2003/XP/2000/97, how do I write a macro that
will ask the user to enter a search value in an InputBox. It
would then look for this string value in an entire column. If
the string is found, it will copy that entire row to a new sheet
in that same file?  For Example,  I want to enter the value
"Mail Box" in an InputBox. Then I want to search Column E for
cells that contain "Mail Box". When the string "Mail Box" is
found, the corresponding row should be copied to a new sheet.
Answer: Let's look at an example.  Download Excel spreadsheet
(as demonstrated below)  Microsoft Excel  In our spreadsheet,
we've created a button on Sheet1 called "Search for String".
When the user clicks on this button, a macro called
SearchForString will run.  Microsoft Excel  This macro will
prompt the user for a search value using an