Hey Jacob, I applied your formula to Sheet2!B1 But I am getting a #Name?
displayed in Cell B1. Am I missing something?

Thanks in advance

"Jacob Skaria" wrote:

Apply this formula in Sheet2!B1
=INDEX(Sheet1!A1:A10,MATCH("*",Sheet1!A1:A10,0))

VBA
Range("Sheet2!B1") = _
WorksheetFunction.Index(Range("Sheet1!A1:A10"), _
Application.Match("*", Range("Sheet1!A1:A10"), 0))


If this post helps click Yes
---------------
Jacob Skaria


"sam" wrote:

Hi Jacob, Thanks for your help.

Using max would work for numberic values rite? I am suppose to display a mix
of alplabets and numbers, something like C34, AI559 etc

So, this type of data would be displayed in any of the cells in
sheet1(A1:A10) and I have to display that in Sheet2(CellB1)

Thanks in Advance

"Jacob Skaria" wrote:

'If you are looking for a formula; In Sheet2 Cell B1 place
=MAX(Sheet1!A1:A10)

'VBA
Sheets("Sheet2").Range("B1") =
Worksheetfunction.Max(Sheets("Sheet1").Range("A1:A 10"))

If this post helps click Yes
---------------
Jacob Skaria


"sam" wrote:

Hi All,

I have a sheet1 where data is diaplayed in column A based on a formula, Now
the data can be displayed anywhere between cell A1 and A10,
What I want to do is: I want to display this value from Sheet1(A1:A10) in
Sheet2 Cell B1

So basically it is a range of cells on sheet1 in column A that the value can
be displayed(it is random) and I want to display that value in Sheet2 Cell B1

Hope I made it clear

Thanks in Advance