On Sheet1 I have a formula
=Sheet2!A1
how do I place a formula in a cell so that the sheet name, i.e Sheet2, is located in a cell. In other words i would like to place "Sheet2" in Cell A2 on Sheet1 and have the formula something like
=c2 & "!A1 vice
=Sheet2!A1
=Sheet2!A1
how do I place a formula in a cell so that the sheet name, i.e Sheet2, is located in a cell. In other words i would like to place "Sheet2" in Cell A2 on Sheet1 and have the formula something like
=c2 & "!A1 vice
=Sheet2!A1