Max,

Thanks again for the assistance. I have made some progress on this little
project. The tricky part is that the number of cells in Sheet1 is going to
vary over time. I plan to experiment with VBA to handle this.

Also,

I understand what the

=IF(Sheet1!A1="","",Sheet1!A1)

does, but I am not sure why this is needed.


Brad


"Max" wrote:

The easiest way to accomplish it is to use a simple link formula in your
destination sheet. Let's say you want to link Sheet2 to data that will be
input in Sheet1's col A. Let's assume that inputs/data is expected only
within Sheet1's A1:A20

In Sheet2,
You could place this in any starting cell, say in B2:
=IF(Sheet1!A1="","",Sheet1!A1)
Then just copy down B2 to B21, to cover the expected data range in Sheet1.
This will do it fine. Test it out. The formulated range will auto-return the
inputs made within Sheet1's A1:A20.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Brad" wrote:
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.