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