Can you set up a simple address book in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
MaryAnn said:
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 i
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 yo
see above,
with sort codes attached. That way i can sort by name, street, are
code, zip or whatever,
just by clicking the top of the column i want it sorted by
 
MaryAnn said:
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 i
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 yo
see above,
with sort codes attached. That way i can sort by name, street, are
code, zip or whatever,
just by clicking the top of the column i want it sorted by
 
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!
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top