Are you querying a database or are you trying to pull the
desired data from a range in a spreadsheet?

Raul
-----Original Message-----
I have a project I am working on where I want to filter
a database full of names and prices. I need to search a
specific title pull the matching results into a listbox
then select one and past it onto another document. It
seems like a waste but it simpifies things a lot for me.
.

I am trying to pull the values from a range on a spreadsheet. Specifically, the name of the sheet is RECORDS, the columns are number, company, part #, standard minute, and number of pieces. I want to type in the first part of the part number search the part # (col C) and then list the closest matches in a listbox. Then I can pick the match I want and pass cells C,D, and E (located in the same row) to another sheet. All the sheets are in the same workbook. I would appreciate any help I can get, I am really stuck

-X