Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display a value from Sheet1-A1:A10 in Sheet2-B1
Is is possible to display a value from a range in sheet1 in a cell in Sheet2?
For eg: In Sheet1, I can get a value in any cell between A1:A10 randomly, the value is a mix of Numbers and alphabers, such as A1i, C3e, D9f etc And I want to display this value in Sheet2 Cell B1 So basically, Scan Sheet1-A1:A10 and locate a cell that has any value displayed(Only one cell will display a value), then display that value in Sheet2-B1 How can this be done? Thanks in Advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display a value from Sheet1-A1:A10 in Sheet2-B1
If all but one cell is blank, then you can do this:
=Sheet1!A1&Sheet1!A2&Sheet1!A3 ... etc to ... &Sheet1!A10 Hope this helps. Pete On Aug 27, 9:27*pm, sam wrote: Is is possible to display a value from a range in sheet1 in a cell in Sheet2? For eg: In Sheet1, I can get a value in any cell between A1:A10 randomly, the value is a mix of Numbers and alphabers, such as A1i, C3e, D9f etc And I want to display this value in Sheet2 Cell B1 So basically, Scan Sheet1-A1:A10 and locate a cell that has any value displayed(Only one cell will display a value), then display that value in Sheet2-B1 How can this be done? Thanks in Advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display a value from Sheet1-A1:A10 in Sheet2-B1
Try this in sheet2!B1 =CONCATENATE(Sheet1!A1,Sheet1!A2,Sheet1!A3,Sheet1! A4,Sheet1!A5,Sheet1!A6,Sheet1!A7,Sheet1!A8,Sheet1! A9,Sheet1!A10,) regards Rajesh Mehmi "sam" wrote in message ... Is is possible to display a value from a range in sheet1 in a cell in Sheet2? For eg: In Sheet1, I can get a value in any cell between A1:A10 randomly, the value is a mix of Numbers and alphabers, such as A1i, C3e, D9f etc And I want to display this value in Sheet2 Cell B1 So basically, Scan Sheet1-A1:A10 and locate a cell that has any value displayed(Only one cell will display a value), then display that value in Sheet2-B1 How can this be done? Thanks in Advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
Click one cell sheet1, display all related recs on sheet2 | Excel Worksheet Functions | |||
If Sheet1 column is marked complete, display entire row on Sheet2? | Excel Worksheet Functions | |||
Display Rows From Sheet1 In Sheet2 (Import) | Excel Worksheet Functions | |||
Combine 3 Columns on Sheet2 to Display in 1 Column on Sheet1 | Excel Worksheet Functions |