Can you set up a simple address book in Excel

[MaryAnn]

Am interested in knowing if anyone has set up a simple address book, contact
list, in Excel as an alternative to the more complex address book in Outlook
and Access

[Desert Piranha]

Am interested in knowing if anyone has set up a simple address book, contact
list, in Excel as an alternative to the more complex address book in Outlook
and Access

Hi Mary Ann,

I just make that stuff from scratch.
Use one row & seperate columns for:

Name-Adderss-city-state-zip-aea code, tele-~~~

Then put text boxes at the top of the coumns like with the names you see above,
with sort codes attached. That way i can sort by name, street, area code, zip or whatever,
just by clicking the top of the column i want it sorted by.

[MaryAnn]

I had a request for one with alpha tabs in Excel but I don't want to set up a
separate worksheet for each letter of the alphabet. I think I'll decline the
request and put it in Access anyway. Thanks for replying!

"Desert Piranha" wrote:

>
> MaryAnn Wrote:
> > Am interested in knowing if anyone has set up a simple address book,
> > contact
> > list, in Excel as an alternative to the more complex address book in
> > Outlook
> > and AccessHi Mary Ann,
>
> I just make that stuff from scratch.
> Use one row & seperate columns for:
>
> Name-Adderss-city-state-zip-aea code, tele-~~~
>
> Then put text boxes at the top of the coumns like with the names you
> see above,
> with sort codes attached. That way i can sort by name, street, area
> code, zip or whatever,
> just by clicking the top of the column i want it sorted by.
>
>
> --
> Desert Piranha
>
>
> ------------------------------------------------------------------------
> Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
> View this thread: http://www.excelforum.com/showthread...hreadid=573337
>
>