How to prepare excels based on records of internal table.

Hi abapers,

I have a scenario as follows:

In my internal table the records are as follows.

col1 col2 col3

1 a1 b1

2 a2 b1

3 a3 b2

4 a4 b3.

Now want i need is i have to break the records on the basis of col3 . All b1 rows are to be taken and dumped in a excel. b2 rows are to be taken and dumped in an excel and similarly for b3. And the name of excel will should be b1, b2 , b3 respectively.

How do i go for the case?

Help would be appreciated..

Regards,

Navin C

Edited by: navin.c on Jun 12, 2009 7:41 AM