I have an excel worksheet that in column A, I have a name of a color, in
Column B I have the color id#, and in Column C I have another ID #.
Now in the same workbook, but on the next Sheet. I want to link the
information from Column A to the first line, whats in Colmn B to the second
line, and whats in Colmn C to the third line, but all in the same cell.

Put this in the cell where you want the result, and format it for "WrapText"

=Sheet1!A1&CHAR(10)&Sheet1!B1&CHAR(10)&Sheet1!C1

hth
Vaya con Dios,
Chuck, CABGx3



"Josie" wrote:

I have an excel worksheet that in column A, I have a name of a color, in
Column B I have the color id#, and in Column C I have another ID #.
Now in the same workbook, but on the next Sheet. I want to link the
information from Column A to the first line, whats in Colmn B to the second
line, and whats in Colmn C to the third line, but all in the same cell.