Get the value of another sheet in a current sheet
By j Miracle
Here i will show how you can get the value of another sheet.
for example , you are on a worksheet sheet1
and you want to access value of cell A2 of sheet2.
then you can use this formula,
=Sheet2!A2
Get the value of another sheet in a current sheet (1094 Views)