Thanks Bob but I've tried that one. "Ready" appears by several items that
are associated with a job but I need to know what jobs show all parts as
"Ready" then generate a list of those jobs on another sheet. That's what
turning out to be a tough one for me to figure out.

"Bob Phillips" wrote in message
...
Could you not just put a formula in F

say in F2: =IF(E2C2,"Ready","")

and copy down, and the autofilter column F on Ready

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bluegrass Fanatic" wrote in message
...
I have a spreadsheet that contains material requirements for specific
jobs.
Each row shows the job number, item number, quantity required for this
job,
the total quantity required for all jobs and the quantity on hand for the
specific item in this row. The combination of job number and item number
is
unique for each job. I need some help in generating a listing of what
jobs
can be worked based on the on hand quantity in Column E.

Here is an example of the worksheet I am using.

Column A Column B Column C Column D Column E
Job Number Description Qty Req'd TTLQty Req'd On Hand Qty
Job 1 Item #1 12 24
35
Job 1 Item #3 11 11
10
Job 1 Item #6 14 26
26
Job 1 Item #4 10 10
15
Job 1 Item #9 33 49
50
Job 2 Item #6 12 26
26
Job 2 Item #9 16 49
50
Job 2 Item #7 18 18
50
Job 2 Item #2 20 20
20
Job 2 Item #1 12 24
35


I am at a loss with how to do this. Is there anyone that can help me
figure
this out?

Regards,

WShelton