I am using Excel 2002 and am a complete novice with Excel. My fiancé runs a consulting & training business. In an effort to help her I started a workbook to track her income and expenses. Sheet One is the Income Sheet, with customers, type of training, date of training, # of people and fee. It keeps a running total of her income for the year. My problem is that when I sort for say all $ received for a particular type of training or from a specific client, etc it continues to show the overall income for the sheet instead of the amount for the sort. This is also true for Sheet Two, the expense sheet. How do I correct this?
Problem # 2: Is there a way to link Sheet One and Sheet Two so that I can see her net income after Income minus Expenses or must I continue to use a calculator to accomplish this?
Thank you for your help.