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