software

I currently have a workbook (sheet X) with 20 or so sheets, each sheet has
the same titles (Dates along the top, jobs down the left), one of these is a
quot;Consolidationquot; sheet, which adds the data of all the other sheets, the other
19 sheets are 1 for each person.

On a different excel document (sheet Y ) I plan on having a date on the top,
and doing a Hlookup of this date on the original workbook on the consolidated
sheet.

Example.
Tom 01/03/06 02/03/06
Job A 15 10
Job B 17 0

Jim 01/03/06 02/03/06
Job A 0 15
Job B 9 6

So on the consolidated sheet it would show the numbers 15, 25, 26, 6
respectively.
On the sheet Y, I could enter the date 01/03/06 and the Hlookups, would tell
me that 15 of Job A was done, and 26 of Job B.

But I also want it to tell me who has done the job. So

Date: 01/03/06
Job A 15 - Tom
Job B 26 - Tom amp; Jim

And I could change the date

Date: 02/03/06
Job A 25 - Tom amp; Jim
Job B 26 - Jim

For this, I initially thought of the formula:
=if(Tom!B2gt;0,1,0) if(Jim!B2gt;0,2,0)
Then a Vlookup of this result against the table
0 Unallocated
1 Tom
2 Jim
3 Tom Jim
For each job each day. This works fine but on the 16th person this table
needs to be 65535 rows deep, and requires a lot of inputting of all the names.

Can anyone help me with this?My approach would be to use a single sheet as a master database, with columns
of NAME...DATE...JOB...QUANTITY
and do the quot;report genreationquot; by using the AutoFilter..........I hate those
quot;one sheet for each whatever, and a consolidation sheetquot; layouts.

hth
Vaya con Dios,
Chuck, CABGx3quot;PaulWquot; wrote:

gt; I currently have a workbook (sheet X) with 20 or so sheets, each sheet has
gt; the same titles (Dates along the top, jobs down the left), one of these is a
gt; quot;Consolidationquot; sheet, which adds the data of all the other sheets, the other
gt; 19 sheets are 1 for each person.
gt;
gt; On a different excel document (sheet Y ) I plan on having a date on the top,
gt; and doing a Hlookup of this date on the original workbook on the consolidated
gt; sheet.
gt;
gt; Example.
gt; Tom 01/03/06 02/03/06
gt; Job A 15 10
gt; Job B 17 0
gt;
gt; Jim 01/03/06 02/03/06
gt; Job A 0 15
gt; Job B 9 6
gt;
gt; So on the consolidated sheet it would show the numbers 15, 25, 26, 6
gt; respectively.
gt; On the sheet Y, I could enter the date 01/03/06 and the Hlookups, would tell
gt; me that 15 of Job A was done, and 26 of Job B.
gt;
gt; But I also want it to tell me who has done the job. So
gt;
gt; Date: 01/03/06
gt; Job A 15 - Tom
gt; Job B 26 - Tom amp; Jim
gt;
gt; And I could change the date
gt;
gt; Date: 02/03/06
gt; Job A 25 - Tom amp; Jim
gt; Job B 26 - Jim
gt;
gt; For this, I initially thought of the formula:
gt; =if(Tom!B2gt;0,1,0) if(Jim!B2gt;0,2,0)
gt; Then a Vlookup of this result against the table
gt; 0 Unallocated
gt; 1 Tom
gt; 2 Jim
gt; 3 Tom Jim
gt; For each job each day. This works fine but on the 16th person this table
gt; needs to be 65535 rows deep, and requires a lot of inputting of all the names.
gt;
gt; Can anyone help me with this?
gt;