I have a text file with a single column of contact / address info with each
address containing 7 rows of data. (sheet1) I want to transpose the rows to
columns (sheet2) so that I can map the data into Outlook.

The following array gives me the results that I want for the second address
by offsetting 7 rows from the previous address.

However, for all the subsequent 800 addresses, I need the formula to
increment the reference points of the offset formulas by 7 more rows. If I
paste this formula in the next row the resulting reference points generated
by excel are A9 and A15. I need the new reference points to be A15 and A21.

Is there a way to force the reference points to increment by 7?
Is there an easier way to do this?

{=TRANSPOSE(OFFSET(Lincolntext4!A8,7,0):OFFSET(Lin colntext4!A14,7,0))}

here is what the first two addresses look like in the source (sheet1) Rows
1-14

Miller Sherrill Blake Eagle CPA PA
Post Office Box 782 236 East Main Street
Lincolnton, NC 28093
Phone: 704-732-2234
Fax: 704-732-6041

www.msbcpa.com
Donna J. Scates, CPA, PA
2817 Highway 27 East
Lincolnton, NC 28092
Phone: 704-735-8786
Fax: 704-735-1584

www.mycpa.com

Thanks!
--
excelhel_p