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

%3CLINGO-SUB%20id%3D%22lingo-sub-2318552%22%20slang%3D%22en-US%22%3EHow%20do%20I%20use%20the%20CELL%20function%20to%20reference%20data%20on%20another%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2318552%22%20slang%3D%22en-US%22%3E%3CP%3E%3DCELL(%22Contents%22)%20without%20the%20reference%20returns%20the%20contents%20of%20the%20last%20updated%20cell%20on%20the%20current%20sheet.%26nbsp%3B%20How%20do%20I%20get%20that%20to%20point%20to%20another%20sheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2318552%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2339135%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20use%20the%20CELL%20function%20to%20reference%20data%20on%20another%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BI%20have%20tried%20numerous%20solutions%2C%20but%20it%20appears%20your%20statement%20is%20correct.%26nbsp%3B%20I%20am%20good%20with%20VBA%2C%20but%20there%20are%20already%20so%20many%20different%20macros%20in%20this%20file%2C%20I'll%20just%20hide%20%3DCELL%20in%20the%20spreadsheet%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2318668%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20use%20the%20CELL%20function%20to%20reference%20data%20on%20another%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2318668%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1043968%22%20target%3D%22_blank%22%3E%40pmpatane%3C%2FA%3E%20You'd%20have%20to%20reference%20a%20specific%20cell%20on%20the%20other%20sheet.%20If%20you%20want%20to%20see%20the%20value%20of%20the%20most%20recently%20changed%20cell%20on%20another%20sheet%2C%20you'd%20need%20VBA%20code.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

2 Replies

@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