View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How to: links on the same page

My guess, maybe: =INDIRECT("B450")
which will always point to & return the contents of B450
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100, Files:360, Subscribers:56
xdemechanik
---
"Erich Koch" wrote in message
...
This should be very easy, BUT can't figure it out.
Excel 2003.

I have a single sheet with 7 columns and around 550 rows.
I made an Index on the top area of the spread sheet with the idea of
linking areas bellow.
I know how to link to something like B450, BUT what I want to link is the
CONTENT on that cell,
so if I insert or delete a row above B450 the link stay intact.

Thanks,
Erich