=CELL("Contents") without the reference returns the contents of the last updated cell on the current sheet. How do I get that to point to another sheet?
@pmpatane You'd have to reference a specific cell on the other sheet. If you want to see the value of the most recently changed cell on another sheet, you'd need VBA code.
@Hans Vogelaar I have tried numerous solutions, but it appears your statement is correct. I am good with VBA, but there are already so many different macros in this file, I'll just hide =CELL in the spreadsheet
