How do I merge cells without losing cell values?

S

Sean

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?
 
B

Bernie Deitrick

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
 
Top