Hello,
My wife and I are tweaking our newly made budget sheet. We mark down expenses, and those quantities are totaled and placed into a given category of expense. Next to that category, I added a column for budgeted amounts. Next to that column is another, where I have each cell calculate the difference between what we've budgeted for a given category and what we've actually spent. Values (negative or positive) in that "difference" column carry over to the next month's budgeted column.
I have attached an image of a blank month to give you an idea of what it looks like.
As the months and years progress, these expense categories are likely to change. Instead of having to change and re-order categories month by month, we have all categories in that column remit to the "Year" summary sheet (highlighted in the image), where we edit categories for the whole workbook. What I just realized, however, is that if I edit the categories listed in the summary sheet, the budgeted values and differences will no longer line up with the expense categories in the month sheets.
Is it possible for me to force a row in the "budgeted" and "difference" columns to stay next to a given text from the "category" column, even when the latter moves up or down because a new category was added?
Many thanks!
Bookmarks