Hi! I work with an excel document with 7 different sheets. its kinda a budget, and I am stuck. I have copied all the information from one sheet to another with the formula ='Total investment'!$A$2:$N$133, and they are moving perfectly together as I want them to do. However, in two of the columns - which are different in all the sheets because its different countries - are not moving when I add a new column in the total investment sheet. If I add one new line - the line shows up in the other sheets but the numbers are not following. So if it says "1" in D5, it should move to D6 when I add a line...
Solved by V. A. in 13 mins