Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / September 2007

Tip: Looking for answers? Try searching our database.

Preparing of Phone Directory

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
isis - 24 Sep 2007 10:26 GMT
Hi everybody,
Could you please help me the "arrnagement of phone guide" asap? Have you got
a ready phone directory sample? I'm using Office 2003. I'm waiting your good
news. Regards,
kassie - 24 Sep 2007 17:46 GMT
Create a new workbook, consisting of 2 worksheets.
In Sheet2, create a list of contact names with tel numbers.
You could use Col A for names, Col B for Tel numbers, Col C for Cell
numbers, and maybe Col D for Fax numbers.  You can extend this to also
include email addresses, postal and residential addresses, depending on your
needs.  Name this tabe Details.

In sheet1, say in Col A6, enter "Contact Name"
In A7, enter "Tel Number"
In A8, enter "Cell Number"
In A9, enter "Fax Number", and so on

In B7, enter =IF(ISERROR(VLOOKUP(A6,Details,1,FALSE)),"No Records
found",VLOOKUP(A6,Details,2,FALSE))
In B8 enter
=IF(ISERROR(VLOOKUP(A6,Details,1,FALSE)),"",VLOOKUP(A6,Details,3,FALSE))
In B8 enter
=IF(ISERROR(VLOOKUP(A6,Details,1,FALSE)),"",VLOOKUP(A6,Details,4,FALSE))

Signature

Hth

Kassie Kasselman
Change xxx to hotmail

> Hi everybody,
> Could you please help me the "arrnagement of phone guide" asap? Have you got
> a ready phone directory sample? I'm using Office 2003. I'm waiting your good
> news. Regards,
David McRitchie - 28 Sep 2007 03:54 GMT
Arrangement of phone directory   (telephone directory)
Phone,  'lastname, firstname',  address,  zipst, zip,  ...

For a department list
Phone,  'lastname, firstname',  title,  department,  ...

You sort on the name and have equal access to the left
of the phone number and to the address on the right.

You probably want to combine  the lastname and firstname
using concatenation      =PROPER(TRIM(C2) & ", " & TRIM(B2))
into a cell to save space hoping that someone with a long
lastname has short first name(s).   You can convert the  formula
to text using  Copy,  Paste Special,  values,  and eliminate
the two original name columns.   Don't use the PROPER function
if your data already has the correct capitalization.

If you get the information from mainframe or a database it
may all be in capitals, in which case you might want to correct
the data by customizing a subroutine from
  http://www.mvps.org/dmcritchie/excel/proper.htm
Customizing because names such as  "McRitchie"  and  "de Bruin"
do not exactly fit converting exactly as proper names.  You will
have to manually fix exceptions that  you don't code for if you
have some that want  "MacKey" and other want "Mackey" which
would not be the same name.

If you have the data  in your contacts list, or your address book
(.WAB) for your email,  then you can export it and choose what
columns you want to include when exporting to a CSV  (comma
separated values) file.    You can move the columns around by
dragging them
  http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse
Signature

HTH,
David McRitchie,  Microsoft MVP -- Excel
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm

>> Could you please help me the "arrnagement of phone guide" asap? Have you got
>> a ready phone directory sample? I'm using Office 2003.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.