Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I insert a row in a source that links to a destination
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I insert a row in a source that links to a destination
As responsed in your other thread in .misc
-------------- In your Master, replace the top left cell where you have this link formula: =salesperson1!A2 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 --- "Bob" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i update links in destination workbook when source workbo. | Excel Worksheet Functions | |||
Paste names from a source workbook to a destination | Excel Discussion (Misc queries) | |||
Data Validation source = destination? | Excel Worksheet Functions | |||
updating destination when I add a line to my source workbook | Excel Worksheet Functions | |||
Automatic update of links in destination file when source file mo. | Excel Discussion (Misc queries) |