I can try to explain it further.
Lets say I have three sheets.
Summary.
January.
List.
In the
list sheet. I've added things like.
Income
Rent
Car costs
...
In the
January sheet. I ad expenses. And after that I choose a category from a drop down menu. All these categories I have, comes from the list sheet.
50 dollars Category: Car costs
200 dollars Category: Rent
500 dollars Category: Income
100 dollars Category: Car costs
...
Then, I have the
Summary sheet. In this sheet all my expenses are shown in a summary.
Rent expenses from January: 200 dollars
Income from January: 500 dollars
Car expenses from January: 150 dollars
Code looks like this...
Code: Select all
=list.A1 "expenses:" =january.A1 "dollars"[/i][/i]
=list.A2 "expenses:" =january.A2 "dollars"[/i][/i]
=list.A3 "expenses:" =january.A3 "dollars"[/i][/i]
The thing is. When I change the categories, in the
list sheet. I want it to change in all other sheets too. It works if I change the name of an already existing category, or add one after all other categories. But the
January and
Summary doesn't update (or work) if I add a category between two already existing categories. How would I make this possible?
Im sorry if I'm not that clear. I need to go to work now, so I hadn't the time to take screenshots and explain it that way.