Wow, thanks for everything--That was truly educational!

You are welcome


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Moon" wrote in message oups.com...
Hi Ron,
Wow, thanks for everything--That was truly educational!
Moon
Ron de Bruin wrote:
Read this page Moon

I think Bob and the late Frank Kabel did a great job
http://www.xldynamic.com/source/xld.LastValue.html

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Moon" wrote in message oups.com...
Hi Ron,
Thanks so much for all your help! That worked as you said. If its not
too much, can you explain a bit about this part of the formula
MATCH(9.99999999999999E+307
Thanks again!
Moon

Ron de Bruin wrote:
Hi Moon

If you copy the formula in Z1 for example it will display the value in
the D column one cell below the last data in C

Is that correct what you see ?

Now you can use Z1 in the macro to build the links on the Summery sheet.
It will always update if you add dates to the C column now

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Moon" wrote in message ups.com...
Hi,
I tried it but I'm probably doing something wrong. So do I place the
formula anywhere in each sheet that I'd like to link the cell to?
And you said to use this cell address; would that be the cell that I
just placed the formula in.
Thanks for clarification.
Moon
Ron de Bruin wrote:
You can try this

Add this formula in each sheet where you want (you can hide it also)

=OFFSET(INDEX(C:C,MATCH(9.99999999999999E+307,C:C) ),1,1)

Use this cell address in the origenal macro on my site
http://www.rondebruin.nl/summary.htm




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Moon" wrote in message ups.com...
Hi,
I have dates in that column.