Easiest would to using the built in Pivot Table report under the Data Menu.

http://www.contextures.com/xlPivot07.html
Debra Dalgleish's site

would be a start.

--
Regards,
Tom Ogilvy

"InfoShare-Industrial Engineers" wrote in message
oups.com...
Hi,

I want to write a macro which will help do the following:

1. read all the data from a worksheet .
2. the data consists of part names , quantities , day on which that
quantity was bought.

3. the macro should enable me to input all the data into an array and
the logic should help me identify the , number of parts with their
quantities per month.

any help in this direction ,
will be appreciated,

Mayukh