Wow guys.
Thanks!
I sent the question just before I left yesterday and have been doing other
tasks but I am about to try your suggestions. I will let you know which seems
to work the best but thanks to all three for the suggestions!

"Peo Sjoblom" wrote:

Is it always the same column and can there be any black cells in-between?

If there can be no empty cells within the range and it is the same column
you can simply use


=INDEX(Sheet2!A:A,COUNTA(Sheet2!A:A))



if there can be empty cells and it is a number you can use


=LOOKUP(99^99,Sheet2!A:A)


if number or test


=LOOKUP(2,1/(Sheet2!A1:A50000<""),Sheet2!A1:A50000)






--


Regards,


Peo Sjoblom



"Wh0079" wrote in message
...
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?