Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate growing range of cells from Sheet1 to Sheet2
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate growing range of cells from Sheet1 to Sheet2
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate growing range of cells from Sheet1 to Sheet2
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate growing range of cells from Sheet1 to Sheet2
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate growing range of cells from Sheet1 to Sheet2
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate growing range of cells from Sheet1 to Sheet2
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. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate growing range of cells from Sheet1 to Sheet2
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. |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate growing range of cells from Sheet1 to Sheet2
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 --- "Brad" wrote: 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. |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate growing range of cells from Sheet1 to Sheet2
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" 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 |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate growing range of cells from Sheet1 to Sheet2
Max,
Thanks for your help, I really appreciate it. Brad "Max" wrote: 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 --- "Brad" wrote: 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. |
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate growing range of cells from Sheet1 to Sheet2
Welcome, Brad
-- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Brad" wrote in message ... Max, Thanks for your help, I really appreciate it. Brad .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
Automatic populate Sheet2 with data from Sheet1 based on criteria. | Excel Discussion (Misc queries) | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
Checking the Cells in Sheet1 with Cells in Sheet2 and replace | Excel Worksheet Functions |