ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel (https://www.excelbanter.com/excel-worksheet-functions/113900-excel.html)

Josie

Excel
 
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.


CLR

Excel
 
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.



All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com