How to make different cells fill in automatically from one entry?

[Coco212]

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

 

[JLatham]

This will work for you if the sheets are set up as I describe below.

First, on your ACTIVITY sheet, you need to set up 2 columns for $ entries,
one column for those amounts that are expenses, another for those $ entries
that are income.
For my example, I'm assuming that on the Activity sheet, column A contains
dates, column B contains the category description, column C contains $
entries that are expenses and column D contains $ entries that are income
amounts.

On the Expenses and Income sheets I assume dates are in column A and
descriptions are in row 1 across the sheets.

In cell B2 on the Expenses sheet you would enter the formula
=SUMPRODUCT(--(Activity!$A$1:$A$1000=$A2),--(Activity!$B$1:$B$1000=B$1),(Activity!$C$1:$C$1000))
You can now fill this formula across and down the sheet to fill the grid
made up by description columns and date rows.
Note that this assumes that the entries on the Activity sheet will go no
farther down the sheet than row 1000. Change that in this formula and the
next one if they could go beyond row 1000.

In cell B2 on the Income sheet you would enter the formula
=SUMPRODUCT(--(Activity!$A$1:$A$1000=$A2),--(Activity!$B$1:$B$1000=B$1),(Activity!$D$1:$D$1000))
Again, fill this formula across and down the sheet as required.

We need to put expense$ and income$ in separate columns on the Activity
sheet so we can distinguish them from one another in case any DESCRIPTIONs on
the Income and Expenses sheets happen to be the same. If absolutely no
description on one of those sheets appears on the other, then you could put
all $ entries in the same column on the Activities sheet.

 

[Coco212]

THANK YOU (yes I am yelling (- That is perfect!
You are a lifesaving ANGEL!!!!
Synthia

 

[JLatham]

Glad I could help, and thanks for letting us know it worked.