Hello from Raabi
Would any geek help me in solving the following problem:
I have two Worksheets: "sheet1" and "sheet2".
In column "Value2" of the "sheet1", I need to put values from the corresponding row numbers and "event" column of the "sheet2".
I tried, in vain, a formula, in each cell of the column "Value2" of the "sheet1"; similar to the following Pseudo syntax:
Please note that the two sheets are fairly large and frequently updated; and therefore just pasting the values from sheet2 is not a viable solution.
Raabi
Would any geek help me in solving the following problem:
I have two Worksheets: "sheet1" and "sheet2".
In column "Value2" of the "sheet1", I need to put values from the corresponding row numbers and "event" column of the "sheet2".
I tried, in vain, a formula, in each cell of the column "Value2" of the "sheet1"; similar to the following Pseudo syntax:
Code:
=CELL("value",sheet2!$B$Row())
Please note that the two sheets are fairly large and frequently updated; and therefore just pasting the values from sheet2 is not a viable solution.
Raabi