What
is the purpose of sheet reference?
Answers
Answered by
2
Answer:
you can use INDIRECT with SHEET, to show the sheet numbers in a list of sheet names. The screen shot below shows a menu sheet, with all the sheet names in the workbook. In the adjacent column, this formula calculates the sheet name. =SHEET(INDIRECT("'" & $B3 & "'!Oct 25, 2018
Explanation:
hope this helps
Answered by
0
Answer:
The purpose of sheet reference is it can be used in a formulae related to Microsoft office excel.To find the data and formulae related to calculate it.
MARK ME BRAINLIEST.....
THANK YOU....
Similar questions