lookup ??

K

kennyken

Hi

I have a column of data which is added to on a daily basis . In anothe
part of the workbook I have a summary sheet . What I would like t
happen is for the last entry in this column to be updated on th
summary sheet . eg each time the user enters a new bit of data onto th
bottom of the column the last entry is what is seen on the summar
sheet

Thank
 
F

Frank Kabel

Hi
if you don't have blank lines in between you could use
something like
=OFFSET('sheet1'!$A$1,COUNTA('sheet'!A:A)-1,0)
 
Top