Look at the Autofilter under the Data menu item.

If you need code, turn on the macro recorder while you perform the action
manually, then modify the code.

Ron also has sample code for analyzing data using an Autofilter.

http://www.rondebruin.nl/copy5.htm


If you are going to utilize Macros, you really need to invest some sweat
equity in learning how understand and modify them as they will certainly
become problematic at some point in the future.

--
Regards,
Tom Ogilvy



"Brian C" wrote in message
...
Hi,

I (with the patient help of Ron De Bruin) created a VBA routine that takes
data from one worksheet, and puts it into another "Database" worksheet,
identifying whether there are duplicate entries and notifying the user if
there are. Here's the link to my previous post:

http://www.microsoft.com/office/comm...0-2b00a8a8741c

Here's the question. Now I'd like to allow the user to find the right
data,
using a text string, and load it back to the original spreadsheet, and
prompt
them with a message of "Customer Not Found" if it doesn't exist. I'd like
them to be able to search with partial strings, show all matching results,
and allow them to select the correct one.

I realize this is a big request, but I'd appreciate any help.

Thanks,

Brian