sorting through unknown source data as it is entered

R

rldjda

If Worksheet1! column A is designated for names and column B is for #sales,
but NO data has been entered in either columns yet, Can I have another
worksheet (Worksheet2! column A & B) create a running list of how many sales
each employee makes to date?

Example:
1) Worksheet1! column A & B is blank to start with
2) Within the next week Column A has 100 different names of salespeople and
Column B has their number of sales
3) Of the 100 names, Peter appears 20 times in column A and his sales in
Column B equals 40
4) I now need Worksheet2!A1 to have "Peter" in the cell and Worksheet2!B1 to
have 40 in the cell. I DON'T want Peter to appear 20 times in Worksheet2!
column A. A1 stays the same, but B2 changes as more Peters are entered in
Worksheet1 column A.
5) I then need the rest of the names and sales in Worksheet2!A2 and B2 to do
the same for the other names.

In essence, one cell in Worksheet2 needs to sort through an entire column in
Worksheet1 AS DATA IS ENTERED. The source data is unknown until it is
entered.
 
M

Martin Fishlock

Hi:

Enter the names on Worksheet2 in the column A:

Ie
[A1]=Peter
[A2]=Jane

now in B1:
=SUMIF(Worksheet2!A:A,A1,Worksheet2!B:B)
and copy if down the list of names.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top