I have text in a cell (A1) that is also the name of a worksheet within my workbook. How do I go about referencing a specific cell on that sheet? I want it to look like the formula below without having to type in the text manually.
='Tab Name'!D16
Wednesday 4 April 2018
worksheet function - Referencing text from one cell into an equation in Excel
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment