generate reports via VBA

Hi All,

I have a requirement to generate the output thru macro.

Input file
---------

FILE-ID BAT SER-NUM RANS EXT-SYS INP-FILE-CD
CS 630 12631 81 D01 5088T43P02
CS 630 12631 82 D01 5088T43P02
CS 630 12631 83 D01 5088T43P02
CS 630 12631 81 D02 5088T43P02
CS 630 12631 82 D02 5088T43P02
CS 630 12641 81 D05 5109T05P04
CS 630 12641 81 D14 5109T05P04
CS 630 12641 82 D14 5109T05P04
CS 630 12641 81 D09 5109T05P04
AS 630 12641 82 D09 5109T05P04
SO 631 11480 83 D09 115BHPREBUILDKIT
CA 631 11480 81 D10 115BHPREBUILDKIT
CS 631 11480 82 D10 115BHPREBUILDKIT
CA 631 11480 83 D10 115BHPREBUILDKIT
CS 631 11480 84 D10 115BHPREBUILDKIT
CS 631 11481 85 D10 115BHPREBUILDKIT

Is it possible to generate the following 2 reports thru excel macro :

1. show the graph with "ext-sys" field and display the highest percentage/count amoung the unique codes.
i.e D10 - 5
D09 - 3
D01 - 3
D02 - 2
D14 - 2
.......to show the above in bar graph displaying each code's count or percentage. (A graph differentiating each codes)

2. The second chart is to display the records according to "ext-sys" field
i.e D10 Sheet showing only D10 records
CA 631 11480 81 D10 115BHPREBUILDKIT
CS 631 11480 82 D10 115BHPREBUILDKIT
CA 631 11480 83 D10 115BHPREBUILDKIT
CS 631 11480 84 D10 115BHPREBUILDKIT
CS 631 11481 85 D10 115BHPREBUILDKIT

D01 sheets showing D01 records only

CS 630 12631 82 D01 5088T43P02
CS 630 12631 83 D01 5088T43P02

similarly for others. whatever unique codes comes in "EXT-SYS" field should be shown in the different sheet or thru link(both options)

Can anyone give me the macro if possible, as iam a beginner to the section.

Thanks,
krish

Your best bet and in the shortest amount of time is to simply build a Pivot table. With the pivot table you can do all of the charting very quickly and automatically.