software

I have a contact sheet with Names, Phone Numbers, Titles and Companies. Here
is my desired end state. I want to create a macro that will allow me to
search by company name or title and have the entire row (name, number,
company and title) copied and pasted on a new sheet. For example, I want to
find all the people on my spreadsheet who are Operation Managers. Then I want
only those people copied and pasted on a new sheet in the workbook to allow
easier contact, so I don't have to search through 600 names to find 30 Ops
Managers. Any ideas out there?

Sean,

Extra sheets of the same information would be a bad idea. Instead, use an
autofilter on your database of contacts. Then just filter on title for
Operation Managers, and you will have your list.

Bernie

quot;Seanquot; gt; wrote in message
...
gt;I have a contact sheet with Names, Phone Numbers, Titles and Companies.
gt;Here
gt; is my desired end state. I want to create a macro that will allow me to
gt; search by company name or title and have the entire row (name, number,
gt; company and title) copied and pasted on a new sheet. For example, I want
gt; to
gt; find all the people on my spreadsheet who are Operation Managers. Then I
gt; want
gt; only those people copied and pasted on a new sheet in the workbook to
gt; allow
gt; easier contact, so I don't have to search through 600 names to find 30 Ops
gt; Managers. Any ideas out there?