Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtering data
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtering data
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering of data - autmatically based on data on other sheet | Excel Discussion (Misc queries) | |||
filtering data | Excel Discussion (Misc queries) | |||
Filtering data | New Users to Excel | |||
filtering data | Excel Programming | |||
Help with Filtering data and matching two data sets? | Excel Programming |