Filter Data

[Marcus]

I am trying to set up a spreadsheet for my personal expenses. What I am tryng
to do is have one sheet were I enter all of my expenses. I then want to have
a tab for each month. What I am trying to do is have the tabs for each month
pull the data from were I enter all of my expenses and filter it so it only
shows the data entered for that month. Can this be done???

 

[yshridhar]

Pivot table is the best option.
with regards
Sreedhar

 

[Gord Dibben]

Marcus

What you ask can be done using VBA but creates a multi-sheeted workbook that is
difficult to manage and update.

Instead, I would suggest you keep everything on one worksheet then use Excel's
filtering, grouping and sorting or a PivotTable to organize your data by any
number of criteria.

With these functions you can isolate by month, type of expense, frequencies and
other criteria.

For working with PivotTables see Debra Dalgleish's site.

http://www.contextures.on.ca/tiptech.html

Scroll down to "P" for pivottable


Gord Dibben MS Excel MVP