Querying a list with Excel
 

I am starting out with a list like


Tech Date Code Actual Billed
DON 11/15/2004 E 5.40 6.00
DON 11/15/2004 W 3.00 4.00
DON 11/15/2004 E 4.00 4.00
DON 11/15/2004 DO 0.30 4.00
DON 11/15/2004 HD 8.00 0.00
Paul 11/15/2004 E 3.00 4.00
Paul 11/15/2004 E 2.30 2.00
Paul 11/15/2004 E 0.40 0.50
Paul 11/15/2004 E 0.60 0.50
Paul 11/15/2004 E 3.00 3.00
Paul 11/16/2004 W 3.00 0.90
Paul 11/16/2004 CV 2.00 2.30
Paul 11/16/2004 CV 2.40 2.00
Fred 11/15/2004 PDI 3.50 4.50
Fred 11/15/2004 W 0.30 0.20
Fred 11/15/2004 W 0.10 0.20
Fred 11/15/2004 W 2.30 3.00
Fred 11/16/2004 LD 2.00 1.50
Paul 11/16/2004 LD 3.00 3.00
Paul 11/16/2004 ST 0.40 0.00
Paul 11/16/2004 E 4.00 3.00
Paul 11/16/2004 E 3.00 4.50

and I want to create a report that looks like this

Beginning date/Ending date Don/Paul/Fred/Paul/etc.
(this has to be dynamic when we add or delete
Tech's)
CV SUM OF TOTAL ACTUAL HOURS BY CODE
E SUM OF TOTAL ACTUAL HOURS BY CODE
PDI ETC.
ST
LD
W
HD
DO

BIGGEST PROBLEMS I HAVE IS GETTING THE TECH NAMES IN THE LIST IN A
COLUMN HEADING AND THEN CALCULATING THE SUM OF EACH CODE BY TECH IN
THE TABLES CELLS.

APPRECIATE ANY HELP I CAN GET

MARTIN

Querying a list with Excel
 

I'd recommend a Pivot Table...

See Debra Dalgleish's beginner's tutorial at

http://peltiertech.com/Excel/Pivots/pivotstart.htm

She's also got a lot more good stuff on PTs at her site:

http://contextures.com/tiptech.html

In article ,
(Martin) wrote:

I am starting out with a list like


Tech Date Code Actual Billed
DON 11/15/2004 E 5.40 6.00
DON 11/15/2004 W 3.00 4.00
DON 11/15/2004 E 4.00 4.00
DON 11/15/2004 DO 0.30 4.00
DON 11/15/2004 HD 8.00 0.00
Paul 11/15/2004 E 3.00 4.00
Paul 11/15/2004 E 2.30 2.00
Paul 11/15/2004 E 0.40 0.50
Paul 11/15/2004 E 0.60 0.50
Paul 11/15/2004 E 3.00 3.00
Paul 11/16/2004 W 3.00 0.90
Paul 11/16/2004 CV 2.00 2.30
Paul 11/16/2004 CV 2.40 2.00
Fred 11/15/2004 PDI 3.50 4.50
Fred 11/15/2004 W 0.30 0.20
Fred 11/15/2004 W 0.10 0.20
Fred 11/15/2004 W 2.30 3.00
Fred 11/16/2004 LD 2.00 1.50
Paul 11/16/2004 LD 3.00 3.00
Paul 11/16/2004 ST 0.40 0.00
Paul 11/16/2004 E 4.00 3.00
Paul 11/16/2004 E 3.00 4.50

and I want to create a report that looks like this

Beginning date/Ending date Don/Paul/Fred/Paul/etc.
(this has to be dynamic when we add or delete
Tech's)
CV SUM OF TOTAL ACTUAL HOURS BY CODE
E SUM OF TOTAL ACTUAL HOURS BY CODE
PDI ETC.
ST
LD
W
HD
DO

BIGGEST PROBLEMS I HAVE IS GETTING THE TECH NAMES IN THE LIST IN A
COLUMN HEADING AND THEN CALCULATING THE SUM OF EACH CODE BY TECH IN
THE TABLES CELLS.

APPRECIATE ANY HELP I CAN GET