copy value of cell from last entry in column

I am trying to write a formula that inputs the value of a cell that is in
another sheet. ex. =sheet1!A:7 How can I write it so it gets the value
from the last entry in the column without me specifying which cell it is.
ex. =sheet1!Athe last cell in the column that has a value in it?)

Thanks for any input

Jay, have a look here for ways to do it,

http://www.xldynamic.com/source/xld.LastValue.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Jay Trull" <[email protected]> wrote in message
news:[email protected]...
> I am trying to write a formula that inputs the value of a cell that is in
> another sheet. ex. =sheet1!A:7 How can I write it so it gets the value
> from the last entry in the column without me specifying which cell it is.
> ex. =sheet1!Athe last cell in the column that has a value in it?)
>
> Thanks for any input