This will return the last numeric value from Sheet2 column B:

=LOOKUP(1E100,Sheet2!B:B)

--
Biff
Microsoft Excel MVP


"MARYINNEED" wrote in message
...
I display (link) one cell on a worksheet page "Houses Sold" from a table
containing a range of cells on another page.

I manually enter the column of numbers, and then go to the next page in
the
workbook and change the cell with "Todays" amount.

How do I make the next page reflect the most current entry in my dated row
of data?

Example:

DATE # of houses sold
1 jan = 1
2 jan = 2
3 jan = 3
4 jan = 4
5 Jan = 5

No one wants to see the raw entry data, they only want to see how many
houses I sold today on a seperate page. How do I make that cell on that
page
reflect the most current entry from the column of data ....(from today)?

Thanks, please help. Mary