Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |