Macro - maintain paste link if new row is added to master spreadsheet
Posted
by
Ross McLaughlin
on Super User
See other posts from Super User
or by Ross McLaughlin
Published on 2012-06-05T21:34:56Z
Indexed on
2012/06/05
22:42 UTC
Read the original article
Hit count: 221
windows-7
|excel-2010
I have a master spreadsheet that has a portion of data (say columns a to e) that paste links to a report. Each row paste links to its own report. If I add a new row to the master spreadsheet I now have the wrong data linking into my reports. I know if I have the reports open when a change is made to the master it will update the reports. However, with the number of reports I will soon have this will no longer be practical. Is there a macro or formula that can be added to maintain the correct data link. I have no real knowledge on such matters and as much information as possible would be greatly appreciated. Many thanks in advance.
© Super User or respective owner