how can we use the sheet reference of another page...???
Answers
Answered by
27
ANSWER!.
To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address. For example, to refer to cell A1 in Sheet2, you type Sheet2!A1. For example, to refer to cells A1:A10 in Sheet2, you type Sheet2!A1:A10.
Answered by
1
To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address. For example, to refer to cell A1 in Sheet2, you type Sheet2!
hope it helps u...
plz follow me...
mark the ans as brainliest....
by kajal s aggarwal.....❤️❤️❤️
meet u soon....
Similar questions