Can Excel Data be simultaneously entered in seperate category list

[Guest]

A monthly personal budget can contain categories such as income, mortgage,
auto gas, food, etc. listed by date expensed.

As the entries are input, is there a way to have excel simultaneously place
the expense into its own worksheet along with the date?

For example in the February monthly budget you enter 85.00 in the Food
column on February 18, 2006. Can this information be simultaneously entered,
by date, in a Worksheet titled Food Expenses? You would, therefore, have a
worksheet summarizing all your monthly expenses and separate worksheets
listing each type of expense by date, or do you just include a running total
for each expense column from month to month?

 

[Roger Govier]

Hi

Take a look at Pivot Tables. They can summarise all of your data by
Income/expense category and by month.
For a start on how to set a Pivot Table up take a look at
http://peltiertech.com/Excel/Pivots/pivotstart.htm
and
http://www.contextures.com/tiptech.html and scroll to the section on
Pivot Tables.