Max,
Thanks for your help. I still dont understand. I guess that I didnt
explain what I am trying to do very well.

Lets say that I have 1 column of data in Sheet1 with 10 rows.
I would like to automatically propagate these 10 cells to Sheet2.
Later, another cell is added (row 11). I would like this new cell to be
automatically propagated to Sheet2 also.

--
Brad


"Max" wrote:

If you meant that the links need to survive whatever new cells/rows/cols that
may be subsequently inserted within the source sheet ...

In Sheet2,
Place in A1:
=OFFSET(Sheet1!$A$1,ROWS($1:1)-1,COLUMNS($A:A)-1)
Copy across/fill down to cover the max expected extent of source data in
Sheet1
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Brad" wrote:
I have a range of cells in Sheet1 that can grow (more cells can be added)

I would like to populate this range of cells from Sheet1 into Sheet2 and
have the range of cells in Sheet2 reflect any new cells added to Sheet1.

Thanks in advance for your assistance.

Brad