Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Excel Data be simultaneously entered in seperate category list
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Excel Data be simultaneously entered in seperate category list
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. -- Regards Roger Govier "bgghunter" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Get excel to list values that occur within raw data | Excel Discussion (Misc queries) | |||
Does Excel 2002 have a List>Create List option under Data? | Excel Discussion (Misc queries) | |||
Export address list data in an Excel worksheet for importing into. | Excel Discussion (Misc queries) |