Forum Discussion

pmpatane's avatar
pmpatane
Copper Contributor
May 03, 2021

How do I use the CELL function to reference data on another sheet?

=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?

excel

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    May 03, 2021

    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.

    • pmpatane's avatar
      pmpatane
      Copper Contributor
      May 09, 2021

      HansVogelaar 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

Resources