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