Displaying Most Recent Info on Different Worksheet

[mwgr5]

I am making a spread sheet that has multiple work sheets. For example, one worksheet displays graphs based on data inputed in a different worksheet. One the page that displays graphs, I want to display the most recent data entered. How could I make the most recent data of specific cells on one worksheet be displayed on another? Thanks.

[Dav]

Post an example, it is easy to reference say the most recent date. what shows that data is the most recent? How is the data laid out?


Regards

Dav

[mwgr5]

Sorry, I guess I didn't provide enough info.

The data on the information sheet is laid out like:

Date.....Data1......Data2
2/07........1............2...
3/07........1.2.........1.5.
4/07........1.1.........1.3.

There is a graph on a different worksheet that displays data like this. Above the graph, I wan't to display the most recent month's data. Since this data has already been inputed in a different data worksheet, I was wondering if there was a way to display the most recent data on the cover worksheet. I want to display the most recent data, so as new dates are added, the cover worksheet would automatically display the most recent data.

Hope this helps. Let me know if you need more information.

[Dav]

I have been on leave for a few days, so sorry about the delay.

I think the attachment is what you need. It is still not entirely clear


Let me know either way

Regards

Dav