Cell A1 of the Input Sheet, for example might contain the words "Daily
Sale Report 5"
Cell A5 of the Output Sheet contains the formula: ='Input Sheet'!$A$1
thus displaying whatever the contents of cell A1 from the Input Sheet.
I want another cell on the Output Sheet to contain the editable results
of the formula ... e.g. "Daily Sale Report 5" ... (NOT the equation).
Is there a way to do this?