Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Querying SQL Server from Excel | Excel Discussion (Misc queries) | |||
Querying a range within Excel | Excel Worksheet Functions | |||
Querying an excel sheet | Excel Discussion (Misc queries) | |||
Querying Excel with SQL | Excel Programming | |||
Web Querying from excel. | Excel Programming |