Use a cell formula to pull the most recent information entered on one sheet to another sheet

JBly

Hello. I am interested in using a cell formula to pull the most recently entered information from one sheet to another. The destination sheet would almost act as a report and would only display two pieces of information - the "Team Health" and "Internal Update".

The reason I would like to do this is to ultimately "link cell data" for most recent Team Health and Most Recent Internal Update to another sheet in my project folder. The way we have it set up now would require us to always update the linked cell each time we add a new update.

Please let me know if I can clarify what I am asking in any way. Thank you!

Paul Newcome

Have you looked into creating a row report instead?

JBly

@Paul Newcome - yes, however what we want to do is link the cells of the row report up to another sheet in our project. As you know, there is no ability to link cells of a row report up to another sheet. This is why we are basically trying to get a sheet to act as a row report by using a cell formula.

Paul Newcome

If the most recent will always be at the top, you can use a basic INDEX function and specify to just pull the first row.

=INDEX({Entire Column To Pull From}, 1)