Can new column entries in linked worksheets be entered in the source worksheet?

  • Thread starter Thread starter Retreatgal
  • Start date Start date
R

Retreatgal

Hi,

I hope someone knows the answer to this.

I have two workbooks which have linked columns of 157 rows and things are
working fine except that when I enter a new row into the source workbook it
doesn't also get added to the dependent workbook.

eg A6:A163 are linked to the same in another workbook. Every now and then I
need to add another entry meaning that if I add two more rows I will need
A6:A166 to be linked. I can do this manually but how can I make this change
happen automatically? Sometimes I will remove rows and archive them so I
need the workbooks to be dynamic.

Any answers?

Retreatgal
 
Hi

Create a link to one cell using relative references, as follows
=IF(YourLink="","",YourLink)
Copy the formula to range, so that all source data you wanted to link are
displayed + so much empty rows as you think being reasonable. When
references are relative, the formula will adjust automatically, and whenever
a new row is added into source workbook, it's displayed in target workbook
as long as there is enough spare rows.
 
Back
Top