ADD UP COLUMN WITH SAME DATE
 

I have a list of jobs that are going to be completed on various days of the
month. I would like to know what the total is each day and then link them to
a seperate summary sheet
Is there some way other than physically adding them on the spreadsheet and
then linking the results as jobs might move during the month

Thanks Stuart

ADD UP COLUMN WITH SAME DATE
 

Hi Stuart

Your best bet sounds like a Pivot Table.
Assuming you have headers to each of your columns, place your cursor inside
your data.
With XL2003 DataListCreate
DataPivot TableFinish
Drag Date to the row area
Drag Jobs to the row area
Drag Jobs again, to the Data area as Count of jobs.

After you have added more data to your List, when you return to the PT right
clickRefresh and your report will be updated.

For more help take a look at
http://www.datapigtechnologies.com/ExcelMain.htm
and
http://www.edferrero.com/Excel
Tutorials/PivotTableTutorial2003/tabbed/89/Default.aspx
and
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/tiptech.html
scroll to section on pivot tables

--
Regards
Roger Govier

"Stuart WJG" wrote in message
...
I have a list of jobs that are going to be completed on various days of
the
month. I would like to know what the total is each day and then link them
to
a seperate summary sheet
Is there some way other than physically adding them on the spreadsheet and
then linking the results as jobs might move during the month

Thanks Stuart