I have rows of data which start in column b with employee numbers, first and
last names, job title etc. Under each row in column C, I have dates of
attendance events and in column E I have a value for each attendance event.
Column B is blank in this list. First I would like to programmitally sort
the date and values ascending so that the latest event is at the bottom of
the list. Then I would like to sum these values in column m of the
information row. They text above and below the date and value columns are
the information rows I would like to do this each employee on the sheet.
Thank you in advance.

db

There are two easy ways to do this. One is using a pivot table (which would
probably be my favorite option. The other is using subtotals. Both options
can be found on the Data menu. If column B is blank I would be inclined to
delete it. Excel makes best guesses for you when sorting, or doing subtotals
orcreating pivot tables. With a blank column it will probably select the
incorrect range for you.

Pivot Table option. Place the Cusor somwhere in your data. Select Data -
Pivot Table. Follow the instructions on the wizard. It will create a new
sheet for you if you just follow the defaults. Drag the items off of the tool
bar onto the table and you should be able to get what you want.

The second option is to create subtotals. You will need to sort your data
first. Sort it by employee. Select Data - Subtotals and use the wizard to
create the subtotals...

HTH

"David Bateman" wrote:

I have rows of data which start in column b with employee numbers, first and
last names, job title etc. Under each row in column C, I have dates of
attendance events and in column E I have a value for each attendance event.
Column B is blank in this list. First I would like to programmitally sort
the date and values ascending so that the latest event is at the bottom of
the list. Then I would like to sum these values in column m of the
information row. They text above and below the date and value columns are
the information rows I would like to do this each employee on the sheet.
Thank you in advance.

db