Convert Spreasheets into a Directory - using Excel 2003

[Jessica]

I have a spreadsheet with several sheets and would like to convert them into
a phone book directory, is this possible? and how would I approach this
project.

Thanks

 

[Gord Dibben]

It would be possible if the worksheets contained names and addresses.

I would place all entries on one worksheet under titles like

LastName, FirstName, StreetNumber, Street, City, State, ZIP, Email, Whatever

Sort by LastName or....................??


Gord Dibben MS Excel MVP

 

[Jessica]

Thanks Gordon, that is exactly the outline that I have. Sorry I failed to
mention that I have setup the information in that format that you have laid
out, and I wish to print them in a booklet form with a table of contents
with page numbers as well.

 

[Gord Dibben]

Most Directories don't need a TOC because data is arranged in alphabetical
order.

Have a look here for some MS Office Address Book Templates.

http://office.microsoft.com/en-us/templates/CT101446711033.aspx

A couple for Excel and one or two for Word.

You could copy into Word if need be.

Booklet printing could be a function of your printer and Page numbering is
standard in Excel or Word.


Gord