Link between files, also include deleted or added rows
I made a new file "budget" which is linked to my project portfolio sheet. I noticed that when I added a new row to the project portfolio sheet, this new row is not added to my file "budget".
The cells in file "budget" are linked with "link from cell in other sheet".
Is this the correct way to appoach this matter?
How can I create a link and be able to also receive newly added rows ?