Hi,

To get the last filled numeric cell in a column use

=LOOKUP(6.022*10^23,Sheet1!A:A)

Which returns the last used cell in column A on sheet 1

Mike

"KeithSimon" wrote:

Hi Everyone,

I have a quesiton, I'm hoping to get some help on. Thanks in Advance!

I have a worksheet with monthly totals and a seperate worksheet with YTD in
the same spreadsheet file. How do I get the totals from one of the columns
in my monthly over to a cell in my YTD spreadsheet dynamically? Meaning as
the totals for the month change, it automatically changes over on the
referenced YTD cell? I hope I was able to articulate this correctly.

Thanks,
Keith