I am in urgent need of macro to process some data. The sample is as
follows. Sheet1 contains data in this format, for only 2 months:

S/N NAME DATE JOINED DEPT
1 BEN 1/11/06 MKT
2 JOHN 5/11/06 ENG
3 JUDE 21/11/06 MKT
4 TINA 5/12/06 MKT
5 PET 31/12/06 ENG

The task therefore is produce a summary on a mothly and departmental
basis in the format below in Sheet2 of same workbook:

NOV.06 DEC 06
MKT 2 1
ENG 1 1

Solution will be highly appreciated.

Create a pivot Table report under the data menu. For the date joined field,
group on Year and Month.

Debra Dalgleish
http://www.contextures.com/tiptech.html

has extensive information on pivot tables if you are not familiar.



--
Regards,
Tom Ogilvy


"sylink" wrote:

> I am in urgent need of macro to process some data. The sample is as
> follows. Sheet1 contains data in this format, for only 2 months:
>
> S/N NAME DATE JOINED DEPT
> 1 BEN 1/11/06 MKT
> 2 JOHN 5/11/06 ENG
> 3 JUDE 21/11/06 MKT
> 4 TINA 5/12/06 MKT
> 5 PET 31/12/06 ENG
>
> The task therefore is produce a summary on a mothly and departmental
> basis in the format below in Sheet2 of same workbook:
>
> NOV.06 DEC 06
> MKT 2 1
> ENG 1 1
>
> Solution will be highly appreciated.
>
>