up vote 0 down vote favorite
share [g+] share [fb]

I have several statements separating my various bank accounts in Calc, they all use the same columns and have a Date column which I sort them by.

I want to create a 'Overview' sheet which contains the rows of all my different sheets and then sort it all by Date so I can see an overview of my finances. How would I go about doing this without having to copy and paste every time I edit my individual sheets?

link|improve this question
feedback

1 Answer

up vote 1 down vote

As far as I understand, your initial design is not efficient. You should have only 1 worksheet, and add extra column for each information type. For example, suppose you have now an additional worksheet per account. You should add a column named "account", and write the account ID into it. You can filter by account, sort by it, add subtitles, etc.

link|improve this answer
hmm that is one way to do it, but i am dealing with a lot of rows and prefer to keep the source data in seperate sheets and each sheet has some other columns which are not the same as the others but i just wish to combine certain similar columns into 1 sheet. – kzap Jan 4 at 17:00
Google Docs has a QUERY or EXPAND function, nothing in Calc? – kzap Jan 4 at 17:01
then your other options are probably pivot table or macros. i don't any other automated option. – Berry Tsakala Jan 6 at 17:12
how do i do it using a pivot table exactly though? is there an example related to this. I'm thinking maybe i should just move it to Google Docs and do it from there – kzap Jan 10 at 7:08
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.