Excel Address Book

[Kamal Subhani]

Can any body help me make an address book in Excel

Suppose in Sheet 1 I have the Raw Data

with column headings

Name , Address , Station, Work Phone, Home Phone Mobile number

How can I make an address book in Excel

Suppose in the AddressBook Sheet

in A1 if we write the letter A the names starting with A will be displayed in Cell A2 Downwards along with the retreived information abt that recoreds Similarly In G1 if we write B then the recored starting with letter B should be retreived from the sheet 1 containing raw data in cell G2 downwards and this goes on in column M1=C S= D and so on

Plz help

 

[Kamal Subhani]

Dear Ian Mac


Andrew M welsh should be in" A " Entry


I hope this helps


Regards


Kamal

 

[soccer]

I'm looking for the same, please any body help, I have searched the whole internet and didn't find a single template for the phone book in excel. wondering people still use phone diary or dash boards for this? If any body have a template please reply.