Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find data within a spreadsheet
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find data within a spreadsheet
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find data within a spreadsheet
Thank you roger
It didnt work, that function is already activated, but we got about 1000 companies and contacts in that list, and some of the people at our company is not very computer litterate, so i have to make it as easy as possible for them. When you use the function u talking abot and you type the name of the company, it only jumps all over, because it goes to the first letter u type, ie, telkom, its gonaa jump to everything that starts with a "T", then to everything that starts with an "E" etc. i need a function, even if i have to do it on a second sheet, to make the person type in telkom, then press enter, and every thing we have with telkom in it displays, allmost like a windows search. Regards Stanley "Roger Govier" wrote: 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find data within a spreadsheet
Hi
Then take a look at Advanced Filter at Debra Dalgleish's site http://www.contextures.com/xladvfilter01.html#ExtractWs -- Regards Roger Govier "Fristy" wrote in message ... Thank you roger It didnt work, that function is already activated, but we got about 1000 companies and contacts in that list, and some of the people at our company is not very computer litterate, so i have to make it as easy as possible for them. When you use the function u talking abot and you type the name of the company, it only jumps all over, because it goes to the first letter u type, ie, telkom, its gonaa jump to everything that starts with a "T", then to everything that starts with an "E" etc. i need a function, even if i have to do it on a second sheet, to make the person type in telkom, then press enter, and every thing we have with telkom in it displays, allmost like a windows search. Regards Stanley "Roger Govier" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
How do I find the last row containing data in a spreadsheet | Excel Discussion (Misc queries) | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Keep find box open while in spreadsheet | Excel Discussion (Misc queries) | |||
FIND DATA WITHIN DATA (V-OR-H LOOKUP/FIND/MATCH?) | Excel Worksheet Functions |