E
excelhel_p
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(Lincolntext4!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
(e-mail address removed)
www.msbcpa.com
Donna J. Scates, CPA, PA
2817 Highway 27 East
Lincolnton, NC 28092
Phone: 704-735-8786
Fax: 704-735-1584
(e-mail address removed)
www.mycpa.com
Thanks!
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(Lincolntext4!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
(e-mail address removed)
www.msbcpa.com
Donna J. Scates, CPA, PA
2817 Highway 27 East
Lincolnton, NC 28092
Phone: 704-735-8786
Fax: 704-735-1584
(e-mail address removed)
www.mycpa.com
Thanks!