On Thu, 21 Aug 2008 17:28:10 -0700, 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?

This formula will return the last value in column C:

=LOOKUP(2,1/(LEN(C:C)0),C:C)

In versions prior to Excel 2007, you may not be able to reference the entire
column; so you might need to change the reference to C1:C65535.
--ron