Home |
Search |
Today's Posts |
#1
|
|||
|
|||
directory with name/address/phone/birthday
I am wanting to know how to go about setting up a format to use for a church
directory. Information in a format similar to below Name phone # address address Anniversary: Birthday: |
#2
|
|||
|
|||
I think you'll have better luck if you put each entry on its own row.
In fact, break up each field into its own column. Going across the worksheet in row 1 (for headers): Salutation FirstName MI LastName Addrees1 address2 city st zip Birthday anniversary .... By putting the data in separate columns, it'll make it easy to combine: =a2&" "&d2 Could return: Ms. Smith Then you could apply Data|Filter|autofilter to show/hide the data you want. And if you ever decide to do a mass mailing (or print labels), you can use this as your database and MSWord as the template. You may want to read some tips for mailmerge. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. Suzanne wrote: I am wanting to know how to go about setting up a format to use for a church directory. Information in a format similar to below Name phone # address address Anniversary: Birthday: -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintain cell links when renaming directory containing multiple f | Excel Worksheet Functions | |||
Can Not Access Directory | Setting up and Configuration of Excel | |||
change directory for refresh data | Excel Discussion (Misc queries) | |||
How do I insert the directory path in my Excel file? | Excel Worksheet Functions | |||
can I query active directory with excel? | Excel Discussion (Misc queries) |