kindly generate code for the problem

[ktraghuram]

hi,

i'm new to vb programming yet i need to get solution for below mentioned problem.


Here i have data like this,


SCHEME YR PIN NAME FATHER_NAME SUB1 SUB2 SUB3

C05 3SEM 06067-M-018 NAGARAJU YAKOOBU 101 102 303

C05 1YR 06067-M-032 SARVESWARRAO PAPAIAH 103

C09 3SEM 09067-M-044 SANTHOSH LAXMAN 302 303

C09 6SEM 07067-M-035 RAMU SRINIVASARAO 601 602 603


now i want the solution to be in the following manner...


the code should generate two excel files namely "C05" and "C09"

and in each file, sheets must be named with sub codes as "101","102","303","103"...etc.

then in "101" sheet the sub code and all other details should be pasted except other sub codes..

(example as: in C05 file

in "101" sheet


SCHEME YR PIN NAME FATHER_NAME SUB1

C05 3SEM 06067-M-018 NAGARAJU YAKOOBU 101


in C09 file

in "603" sheet


SCHEME YR PIN NAME FATHER_NAME SUB1 SUB3

C09 6SEM 07067-M-035 RAMU SRINIVASARAO 603


i request all the developers to kindly generate the code as it will be very helpful our college.

thanking you,


regards,

K.T.Raghuram