software

Hello all,

I have learned very much from this site. Thanks to all.
So, I figured I would see anyone could help me directly on my next
problem.

On to my latest project.

I need to use data entered in a column(s) to determine which cells to
place the copied data in.

I have a worksheet that lists my completed jobs.
Since I sometimes use sub contractors, not everyone works a regular
schedule, except me. So some days I will be the only one working. I am
listed for each day / job. I need to use my master job list, to update
each persons and payment (job date amp; job #, at a later time), without
entering it 2 times or cut amp; paste, to avoid omissions or mistakes.

When I enter a job on the master list, it automatically updates the
Quick List on the same worksheet. That is the list I use to write
checks from and keep track of workers payments.

Basically, use data to update different cells based on the persons
name.
I have peoples names repeating randomly in column G (ex. G5:G370).
I have the payment (dollar amount) for the person in Column H
(H5:H370).
There are some blanks in those columns. I could enter a quot;filler data /
null value) if needed. There are many columns that I fill with each
jobs details. I just want selected info for the Quick List for quick
reference.In the preview, the columns were compressed So I will list each
column.

A is the job date
B is the job #
G is Sub Contractor name
H is sub contrcators payment

Main List Data

A B G H Columns not relevent
are omitted.
Date Job# Sub Cont Payment
01/05/06 005 Donna 363.00
01/06/06 006 Donna150.00
01/08/06 008 *** 0.00 No name in column G indicates
a job
01/10/06 010 Larry115.00 on that day, but no sub contractors

01/12/06 012 Don110.00 worked on that job.
01/14/06 014 Larry 115.00
01/15/06 015 Donna115.00
01/16/06 016 Don 110.00
01/24/06 024 *** 0.00
01/25/06 025 Donna150.00
01/30/06 030 Don110.00

I also have each person listed, in a workers Quick List at the bottom
How can I take the dollar amount and copy it under the persons name, in
the next empty cell? I have not expanded the Quick List to include the
additional fields (date amp; job #), that will come later.Workers Quick List

Donna Larry Don
Amt Amt Amt
363.00 115.00 110.00
150.00 115.00 110.00
115.00 110.00
150.00

If I haven't been clear enough in my explainations, let me know. I will
try to clarify. I have a few oher questions, but these are the most
important at this time.

Thanks in advance for your help,
Harv--
Harv
------------------------------------------------------------------------
Harv's Profile: www.excelforum.com/member.php...oamp;userid=34344
View this thread: www.excelforum.com/showthread...hreadid=541203Seeing you want to sum underneath the name, I take it you have the list in
one row, say A500:E500. Then in A501, enter
=SUMIF($G$5:$G$375,A500,$H$5:$H$375).
Copy this across to the other cells, and you will have the totals for each.

quot;Harvquot; wrote:

gt;
gt; Hello all,
gt;
gt; I have learned very much from this site. Thanks to all.
gt; So, I figured I would see anyone could help me directly on my next
gt; problem.
gt;
gt; On to my latest project.
gt;
gt; I need to use data entered in a column(s) to determine which cells to
gt; place the copied data in.
gt;
gt; I have a worksheet that lists my completed jobs.
gt; Since I sometimes use sub contractors, not everyone works a regular
gt; schedule, except me. So some days I will be the only one working. I am
gt; listed for each day / job. I need to use my master job list, to update
gt; each persons and payment (job date amp; job #, at a later time), without
gt; entering it 2 times or cut amp; paste, to avoid omissions or mistakes.
gt;
gt; When I enter a job on the master list, it automatically updates the
gt; Quick List on the same worksheet. That is the list I use to write
gt; checks from and keep track of workers payments.
gt;
gt; Basically, use data to update different cells based on the persons
gt; name.
gt; I have peoples names repeating randomly in column G (ex. G5:G370).
gt; I have the payment (dollar amount) for the person in Column H
gt; (H5:H370).
gt; There are some blanks in those columns. I could enter a quot;filler data /
gt; null value) if needed. There are many columns that I fill with each
gt; jobs details. I just want selected info for the Quick List for quick
gt; reference.
gt;
gt;
gt; In the preview, the columns were compressed So I will list each
gt; column.
gt;
gt; A is the job date
gt; B is the job #
gt; G is Sub Contractor name
gt; H is sub contrcators payment
gt;
gt; Main List Data
gt;
gt; A B G H Columns not relevent
gt; are omitted.
gt; Date Job# Sub Cont Payment
gt; 01/05/06 005 Donna 363.00
gt; 01/06/06 006 Donna150.00
gt; 01/08/06 008 *** 0.00 No name in column G indicates
gt; a job
gt; 01/10/06 010 Larry115.00 on that day, but no sub contractors
gt;
gt; 01/12/06 012 Don110.00 worked on that job.
gt; 01/14/06 014 Larry 115.00
gt; 01/15/06 015 Donna115.00
gt; 01/16/06 016 Don 110.00
gt; 01/24/06 024 *** 0.00
gt; 01/25/06 025 Donna150.00
gt; 01/30/06 030 Don110.00
gt;
gt; I also have each person listed, in a workers Quick List at the bottom
gt; How can I take the dollar amount and copy it under the persons name, in
gt; the next empty cell? I have not expanded the Quick List to include the
gt; additional fields (date amp; job #), that will come later.
gt;
gt;
gt; Workers Quick List
gt;
gt; Donna Larry Don
gt; Amt Amt Amt
gt; 363.00 115.00 110.00
gt; 150.00 115.00 110.00
gt; 115.00 110.00
gt; 150.00
gt;
gt; If I haven't been clear enough in my explainations, let me know. I will
gt; try to clarify. I have a few oher questions, but these are the most
gt; important at this time.
gt;
gt; Thanks in advance for your help,
gt; Harv
gt;
gt;
gt; --
gt; Harv
gt; ------------------------------------------------------------------------
gt; Harv's Profile: www.excelforum.com/member.php...oamp;userid=34344
gt; View this thread: www.excelforum.com/showthread...hreadid=541203
gt;
gt;


I don't want the sum of the list...

What I want is to list each of the job amounts for each person. I want
a quick reference of jobs completed, paid amp; outstanding.

For each person I want

Donna
115.00
150.00
115.00
300.00

I have the totals for each person. That is calculated and averaged. I
just want to look to see who I owe and for what jobs.--
Harv
------------------------------------------------------------------------
Harv's Profile: www.excelforum.com/member.php...oamp;userid=34344
View this thread: www.excelforum.com/showthread...hreadid=541203
I don't want the sum of the list...

What I want is to list specific info from each job, for each sub
contractor.

I want a quick reference of job info. I can then determine the
completed, paid amp; outstanding amounts due.

I want to enter all job info in the main section.
(job date / job # / job total fee / My Name / My fee / Sub Cont name /
sub cont fee / etc.)

Then have the job date / job number / sub contractor fee) automatically
entered in the quick reference list below the main section.

For each person I want a list like the following.

Donna

Job Date.....Job#......Fee
4/18/06.......108.....115.00
4/21/06.......111.....150.00
4/24/06.......114.....115.00
4/25/06.......115.....300.00

I have the sum totals for each person.
That is calculated and averaged.Thanks,
Harv--
Harv
------------------------------------------------------------------------
Harv's Profile: www.excelforum.com/member.php...oamp;userid=34344
View this thread: www.excelforum.com/showthread...hreadid=541203