#1   Report Post  
Old October 28th 04, 11:29 PM
Sal Iaccarino
 
Posts: n/a
Default Cell Shift

We have the following in our spread sheet:







Column A
Column B

Column D
Column E
Column F
Column G
Column H

NAME
ADDRESS

TELEPHONE
Away Address
Away City & State
Away Zip
Away telephone

Alibrandi, Patricia
7455 Jacaranda Park Rd, S203

514-2840





Allard, Michael/Shirley Giquere
2635 Magnolia Park Ln, NY102

598-9268
57 Ridgetop Rd.
Wallingford, CT
06492
203-265-3164

Allard, Raymond & Zalita
7436 Plumbago Bridge Rd, N203

566-7762
18 State Rd.
Dannemora, NY
12429
716-532-0177

Allen, Philip & Marguerite
2615 Magnolia Park Ln, NW101

513-1771














We would like to prepare in the following format for a printed
telehone book. Can this be accomplished via a formula?



Would appreciate any suggestions to reduce work to accomplish this
format.















Column A
Column B

Column D





NAME
ADDRESS

TELEPHONE





Alibrandi, Patricia
7455 Jacaranda Park Rd, S203

514-2840














Allard, Michael/Shirley Giquere
2635 Magnolia Park Ln, NY102

598-9268






57 Ridgetop Rd., Wallingford, CT, 06492

203-265-3164














Allard, Raymond & Zalita
7436 Plumbago Bridge Rd, N203

566-7762






18 State Rd., Dannemora, NY, 12429

716-532-0177














Allen, Philip & Marguerite
2615 Magnolia Park Ln, NW101

513-1771








  #2   Report Post  
Old October 29th 04, 03:25 AM
JulieD
 
Posts: n/a
Default

Hi Sal

best thing to do is to set up the format of the address book in Word and use
Excel as the mail merge source file.

If you decide to use this approach and have Word ver 97 or 2000 feel free to
email me direct for some notes on mail merge (julied @ hcts dot net dot au)
for Word ver 2002/2003 have a look at
http://homepage.swissonline.ch/cindy...r/MergFram.htm

Hope this helps
Cheers
JulieD

"Sal Iaccarino" wrote in message
. ..
We have the following in our spread sheet:







Column A
Column B

Column D
Column E
Column F
Column G
Column H

NAME
ADDRESS

TELEPHONE
Away Address
Away City & State
Away Zip
Away telephone

Alibrandi, Patricia
7455 Jacaranda Park Rd, S203

514-2840





Allard, Michael/Shirley Giquere
2635 Magnolia Park Ln, NY102

598-9268
57 Ridgetop Rd.
Wallingford, CT
06492
203-265-3164

Allard, Raymond & Zalita
7436 Plumbago Bridge Rd, N203

566-7762
18 State Rd.
Dannemora, NY
12429
716-532-0177

Allen, Philip & Marguerite
2615 Magnolia Park Ln, NW101

513-1771














We would like to prepare in the following format for a printed
telehone book. Can this be accomplished via a formula?



Would appreciate any suggestions to reduce work to accomplish this
format.















Column A
Column B

Column D





NAME
ADDRESS

TELEPHONE





Alibrandi, Patricia
7455 Jacaranda Park Rd, S203

514-2840














Allard, Michael/Shirley Giquere
2635 Magnolia Park Ln, NY102

598-9268






57 Ridgetop Rd., Wallingford, CT, 06492

203-265-3164














Allard, Raymond & Zalita
7436 Plumbago Bridge Rd, N203

566-7762






18 State Rd., Dannemora, NY, 12429

716-532-0177














Allen, Philip & Marguerite
2615 Magnolia Park Ln, NW101

513-1771











Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you delete a cell then shift cell up? Isela Excel Discussion (Misc queries) 4 January 22nd 05 02:41 AM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 08:18 AM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 03:06 AM
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 1 December 2nd 04 09:30 PM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017