Extracting Certain Information From Excel

[Youtalk]

Need some help from you Excel Guru's.

I have a huge excel list, and I need to extract only certain parts of the data.

What I'd like to do is pick certain fields, and the row next to it to extract and consolidate it into a new sheet.
Example: If the word contact, phone, email, etc comes up, I want that field, and the row next to it copied and pasted into another sheet.
I'd need the formula or function to run the entire list and process accordingly. Now the rows and columns are not always the same, so it would
need to find the specific words I placed.

Is this possible?

Here's a snap shot of the list. This is actually two columns.
Contact Bob
Title Buyer
Phone 1-000-000-0000
Fax State
Salutation Country
User Fields
# Employees: Buyer Info:
# Buyers: User 10
Purchasing by: User 11
Commodity: User 12
Product Mfg.: User 13
Salesman: Prospects
Working Ho... User 15
Subsidiaries?
Home/Phone
Alt Phone Ext.
Mobile Phone Home Address 2
Pager Home City
Home Phone Home State
E-mail Address [email protected]

[arlu1201]

So only rows containing contact, phone and email should be picked up and copied to the next sheet?

[nicdyb]

Try my attachment, if it doesnt work, change all the ";" in the formulas to ","


Put your data in sheet 2 "INPUT"