Take a look at the offset function. You'd need something like this

=OFFSET(A1,0,COUNT(Sheet1:A:A),1,1)

Here is some explanation on OFFSET

http://www.mvps.org/dmcritchie/excel/offset.htm
--
HTH,
Barb Reinhardt



"Wh0079" wrote:

Hello.
I am looking to reference the last cell that contains data from one sheet
onto another sheet in my workbook. The issue I am having with this is that
this cell will change (however I can limit the reference to a specific
range).
Is there a way to dynamically reference a range of cells without having to
go back and adjust the lookup manually?