Done! I recalled I did this in another sheet.

I added a new tab ‘non-fixed categories’ where you can add, delete or modify the existing non-fixed categories. These fields in tab ‘non-fixed categories’ will be pulled in two places:
- To the Overview tab via an ArrayFormula in field B24,
- And to all the dropdown fields in all the other tabs where you can write down your individual expenses.

Now if we need to make an adjustment, we only have to make it once. Hope this is helpful. Thanks again for sharing your idea!

Written by

Writing my way to progress. Topics: personal growth, life lessons, tooling & (failed) ventures.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store