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.