Hi, I have a workbook with three sheets: Activity, Expenses, Income.
I only want to enter data on the Activity sheet.
I select the date, I select the DESCRIPTION (matches the sheets Expenses and
Income) and I select the Category (Categories match columns on Expenses and
Income sheets). I already set up the selections, the Category is a data value
dependent (indirect) function.
When I enter data on the Activity sheet I want it to appear automatically
where it belongs on the Expenses or Income sheets. - in the row for the date
(already there) in the column for the Category selected (columns already
there) - adding to any value already there is there is a value in that cell.
So, On Activity sheet, I if I select 01/02/10, select Expenses, select
Groceries, and enter $11.00, then later go in and select 01/02/10, select
Expenses, select Groceries, and enter 32.00, the total of 33.00 shows upon
the Expenses sheet, in the row for 01/02/10, under the column Groceries.
Any help would be greatly appreciated.
Synthia