Hi

Just use DataFilterAutofilter and use the dropdown to select company.
All of the data across all columns will show for just that company name.

--
Regards

Roger Govier


"Fristy" wrote in message
...
Hi All
I've created a spreadsheet with all our companys phone numbers.
I wanna create a search that will display all the information of what
im
searching for.
Ive got 6 colums
company, contact, tel number, fax number, cell number, refference

basiccaly when i search a company, or contact, i want all the
information
under the searched company or name to display in the same colums as it
is
displayed above.

Regards