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
--
Paul

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


On Sat, 29 Mar 2008 15:05:00 -0700,
wrote:

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

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.

--
Paul


"Gord Dibben" wrote:

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


On Sat, 29 Mar 2008 15:05:00 -0700,
wrote:

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

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/te...446711033.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


On Sat, 29 Mar 2008 15:46:00 -0700,
wrote:

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.