Categorize data based on a condition?

[macke05]

Hi everyone,
I've got a problem that is very straight forward that is beyond my abilities. It is as follows: I have a sheet that tracks all expenses and info regarding them (Date of expense, check number, expense item, dollar amount), where all info regarding a particular expense is stored side by side in a row. One piece of info I record is what category that expense falls into (Utility, mortgage, travel, ect.). I am looking to find a solution that upon inserting the category type would copy all info relating to the expense into a seperate sheet that would have each category separated and broken down.

Thank you for all your ingenuity!!

-Ethan Mack

 

[My Aswer Is This]

Are you saying if you enter Gas into column C that row of data will be copied to a sheet named Gas?
And the sheet named Gas has already been created?

 

[alansidman]

Sounds like a Pivot Table may do what you need.

 

[macke05]

Thank you alansidman! A pivot table was the solution!

-Macke05

 

[My Aswer Is This]

That's great. I have only played with Pivot Tables a little. I need to work with them more and see exactly how they work.

Never have tried having data in one sheet and Pivot Table in another sheet. But I do see how that would work.