Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keep track of phone numbers
First off I posted this question yesterday, but for some reason with my
internet server provider I was unable to see my post or any replies if there were any, so please accept my apologies if anyone replied and I did not reply to you. The problem has now been resolved, so I hope it is acceptable to post again given the problems I was having. 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keep track of phone numbers
On Jul 12, 4:15*am, "Eamon" wrote:
First off I posted this question yesterday, but for some reason with my internet server provider *I was unable to see my post or any replies if there were any, so please accept my apologies if anyone replied and I did not reply to you. The problem has now been resolved, so I hope it is acceptable to post again given the problems I was having. 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 Eamon, you provided no detail as to what what version of Excel you are using or the columns that are on your alphabetic pages. I'm using Excel 2003. On the assumption you have columns like firstname,lastname, business name, city, phone, fax, birthdate (or whatever). I would enter the data on a single page and then use the autofilter command.(datafilterautofilter). ***Read about it in help(f1)*** You will be able to locate everyone whose firstname starts with "J" and lives in your selected city rapidly. Just remember to change your search conditions. Suggestion: create a worksheet with six entries and try out the commmand. Hope this makes your life easier...Don |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keep track of phone numbers
On Jul 12, 6:15*am, "Eamon" wrote:
First off I posted this question yesterday, but for some reason with my internet server provider *I was unable to see my post or any replies if there were any, so please accept my apologies if anyone replied and I did not reply to you. The problem has now been resolved, so I hope it is acceptable to post again given the problems I was having. 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 see my post on your re-post of this question |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keep track of phone numbers
Hi,
Thanks to everyone for your suggestion I have not had a chance to try them out yet but will do so as soon as I can. Thanks again and much appreciated. Regards, Eamon "Eamon" wrote in message ... First off I posted this question yesterday, but for some reason with my internet server provider I was unable to see my post or any replies if there were any, so please accept my apologies if anyone replied and I did not reply to you. The problem has now been resolved, so I hope it is acceptable to post again given the problems I was having. 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 | |||
spreadsheet to keep track of phone numbers | Excel Worksheet Functions | |||
spreadsheet to keep track of phone numbers | Excel Worksheet Functions | |||
Spreadsheet to keep track of phone numbers | Excel Worksheet Functions | |||
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) |