How to get a value of data from the last rows of a table. sheet1 content a
data table. Data rows is increasing daily. Sheet2!A1 is showing the last data
entered in sheet1.

All this while i am using =sheet1!$D100 to get the data, but I need to
update the formula daily. Is there any formula for this situation?

In Sheet2,
you could use something like this in A1:
=LOOKUP(2,1/(Sheet1!D2:D100<""),Sheet1!D2:D100)
to extract the last row value in Sheet1's col D

Adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Eddie" wrote:
How to get a value of data from the last rows of a table. sheet1 content a
data table. Data rows is increasing daily. Sheet2!A1 is showing the last data
entered in sheet1.

All this while i am using =sheet1!$D100 to get the data, but I need to
update the formula daily. Is there any formula for this situation?

try this simple where 9999 is larger than any number possible in col d
=lookup(9999,Sheet1!d:d)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Eddie" wrote in message
...
How to get a value of data from the last rows of a table. sheet1 content a
data table. Data rows is increasing daily. Sheet2!A1 is showing the last
data
entered in sheet1.

All this while i am using =sheet1!$D100 to get the data, but I need to
update the formula daily. Is there any formula for this situation?

In Sheet2,
you could use something like this in A1:
=LOOKUP(2,1/(Sheet1!D2:D100<""),Sheet1!D2:D100)
to extract the last row value in Sheet1's col D

Adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Eddie" wrote:
How to get a value of data from the last rows of a table. sheet1 content a
data table. Data rows is increasing daily. Sheet2!A1 is showing the last data
entered in sheet1.

All this while i am using =sheet1!$D100 to get the data, but I need to
update the formula daily. Is there any formula for this situation?

Hi,

assuming you are looking for the item in column D:

Last Number: =LOOKUP(9^9,D:D)
Last Text enry: =LOOKUP(REPT("z",255),D:D)
Last Non-blank cell: =LOOKUP(2,1/(B:B<""),B:B)
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Eddie" wrote:

How to get a value of data from the last rows of a table. sheet1 content a
data table. Data rows is increasing daily. Sheet2!A1 is showing the last data
entered in sheet1.

All this while i am using =sheet1!$D100 to get the data, but I need to
update the formula daily. Is there any formula for this situation?