CODE FOR DATA SUMMARY
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.
|