I'm making a souped-up cheque-balancing spreadsheet for planning how
much I can save and spend on my limited student's allowance.
First there is a sheet with nine tables of various recurring and
non-recurring incomes and expenditures.
Then a sheet that translates those to rows with date, description,
debit, credit
Then a table that has rows of all days's dated from now until 2010,
with nine rows per date and details filled in from the previous sheet,
but with most of the entried blank.
Finally, what I want to do but am stuck on is to consolidate that sheet
to another that just has the rows with items so that I can add columns
with running totals. I would like to be able to add daily transactions
to that sheet... but I suppose that I could add another table to the
first sheet for that.
I could do this manually by making a column that has the row number of
valid rows and is otherwise blank and sorting the sheet by that column,
but I'm looking for an automatic method so that any change in the first
table propagates automatically through to the last.
If I could conditionally hide the blank rows.... but I can't find a way
to do that.
Any advice appreciated.
Bookmarks