Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CODE FOR DATA SUMMARY
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data summary | Excel Discussion (Misc queries) | |||
DATA SUMMARY | Excel Worksheet Functions | |||
help with code for conditional summary sheet | Excel Discussion (Misc queries) | |||
Summary data | Excel Discussion (Misc queries) | |||
Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel |