How can I insert a row in a source that links to a destination

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a workbook with a number of source sheets that feed into a
destination sheet on the same workbook. I want to be able to insert and
delete rows into the source sheets and have those changes replicated on the
destination sheet.

It works if the destination work sheet is in a different workbook and that
workbook is located on a different device on the network.
 
As responsed in your other thread in .misc
--------------
In your Master,
replace the top left cell where you have this link formula:
=salesperson1!A2
Click to expand...

with this:
=OFFSET(salesperson1!$A$2,ROWS($1:1)-1,COLUMNS($A:A)-1)
Copy across / fill down as required to link it. Cover the max expected range
in the propagation. Test it out. The above will survive any new row
insertions/deletions in salesperson1 within the range covered, giving you
what you seek.

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
 
Back
Top