Populate growing range of cells from Sheet1 to Sheet2

[Brad]

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

 

[Max]

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]

Max,
Thanks for your help. I still don’t understand. I guess that I didn’t
explain what I am trying to do very well.

Let’s 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,
Thanks for your help. I still don’t understand. I guess that I didn’t
explain what I am trying to do very well.

Let’s 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,
Thanks for your help. I still don’t understand. I guess that I didn’t
explain what I am trying to do very well.

Let’s 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]

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]

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]

You could try posting in .programming for a vba solution if no one else jumps
in here with the vba for you

=IF(Sheet1!A1="","",Sheet1!A1)
.. but I am not sure why this is needed.

If you mean, why not just use: =Sheet1!A1 ?
That's because blank source cells will be evaluated by Excel & returned as
zeros. The IF construct above suppresses these zero returns by returning
"blanks", viz.: "" which gives a neater look
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

 

[PJY]

this is not a VBA solution, however, it may help. In sheet 2 in cell A1, type
=Sheet1!A1 then copy that formula for as far as you think you need to go, now
any new rows or columns in sheet 1 will automatically populate in sheet 2,
along with any changes you make to sheet 1.

 

[Brad]

Max,

Thanks for your help, I really appreciate it.

Brad

 

[Max]

Welcome, Brad
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

Max,

Thanks for your help, I really appreciate it.

Brad

..