Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheet to keep track of phone numbers
I am setting up a spreadsheet to keep track of phone numbers.
The workbook has worksheets named "A", "B", "C", "D" etc! The first worksheet is named "Menu" and contains all the letters of the alphabet with macros to link to the various worksheets, for example if I click on "A" it will go to the worksheet named "A" that contains all company names and phone numbers for companies that name starts with "A" What I would like to do is set up a something on the "Menu" worksheet that could search the workbook by the company name. For example if I was to type a company name such as "AIB" it would return the number for "AIB". Would this be possible and if so what would be the best way to go about it? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a way to keep track of incoming phone calls | Excel Discussion (Misc queries) | |||
How do you remove duplicate phone numbers in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
Template track phone traffic to determine weekly, monthly trends. | New Users to Excel | |||
how to use excel to track phone numbers | New Users to Excel | |||
How can I cross reference phone numbers with existing phone numbe. | Excel Discussion (Misc queries) |