software

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,

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 amp; 2003

quot;Jay Trullquot; gt; wrote in message
...
gt; I am trying to write a formula that inputs the value of a cell that is in
gt; another sheet. ex. =sheet1!A:7 How can I write it so it gets the value
gt; from the last entry in the column without me specifying which cell it is.
gt; ex. =sheet1!Athe last cell in the column that has a value in it?)
gt;
gt; Thanks for any input