Is there is a way in excel to filter data and have the results copied to another excel spreadsheet?

Question

I have an excel spreadsheet that I use to track my expenses. In one spreadsheet I list all the expenses that i have then I select which account was used to pay for this item. Then I have separate spreadsheets for each of my accounts. I am looking for a way where I can just enter the information once into the spreadsheet that tracks all my expenditures and the information will show up in the spreadsheet for the appropriate account. I was wondering if I could do this with a filer in some fashion.

Answer 1

Advanced filter could do that, but you will need to run Advanced filter every time you change info in the main sheet.

I will recommand you to use one of the:
1- DSUM, DCOUNT, or any of D-functions found in Excel to do this, you may use the DSUM for each account in each sheet to solve it.
2- Use some extra powerful functions, like OFFSET, INDIRECT, etc.
3- use some Macro to do it

In all of these three options, you may send me your details in Y! Answers.

I can do it in any of these ways, but I need more info

Trust me, I am the VBAXLMan

Answer 2

Pivottables will set this up nicely for you.