I have a user form List having data like this
| Roll No. | Name | Course | Session | Fee |
| 123456 | SUNI | ABC12 | MAY14 | 100 |
| 789012 | GOPI | DEF95 | JAN16 | 300 |
| 567891 | RANI | GHK67 | JUN17 | 100 |
| 123456 | REET | ABC12 | AUG15 | 100 |
| 456231 | LILA | DEF95 | DEC18 | 300 |
I want to create a table in same file in a sheet like this
| Roll No. | Name | Course | Session | Fee |
--------------------------------------------------------------------
ABC12
--------------------------------------------------------------------
| 123456 | SUNI | ABC12 | MAY14 | 100 |
| 123456 | REET | ABC12 | AUG15 | 100 |
--------------------------------------------------------------------
DEF95
--------------------------------------------------------------------
| 456231 | LILA | DEF95 | DEC18 | 300 |
| 789012 | GOPI | DEF95 | JAN16 | 300 |
--------------------------------------------------------------------
GHK67
--------------------------------------------------------------------
| 567891 | RANI | GHK67 | JUN17 | 100 |
--------------------------------------------------------------------
Do anyone have Idea of VBA how to do this with multiple select from list OR one by one click entry from userform listbox
Thanks
| Roll No. | Name | Course | Session | Fee |
| 123456 | SUNI | ABC12 | MAY14 | 100 |
| 789012 | GOPI | DEF95 | JAN16 | 300 |
| 567891 | RANI | GHK67 | JUN17 | 100 |
| 123456 | REET | ABC12 | AUG15 | 100 |
| 456231 | LILA | DEF95 | DEC18 | 300 |
I want to create a table in same file in a sheet like this
| Roll No. | Name | Course | Session | Fee |
--------------------------------------------------------------------
ABC12
--------------------------------------------------------------------
| 123456 | SUNI | ABC12 | MAY14 | 100 |
| 123456 | REET | ABC12 | AUG15 | 100 |
--------------------------------------------------------------------
DEF95
--------------------------------------------------------------------
| 456231 | LILA | DEF95 | DEC18 | 300 |
| 789012 | GOPI | DEF95 | JAN16 | 300 |
--------------------------------------------------------------------
GHK67
--------------------------------------------------------------------
| 567891 | RANI | GHK67 | JUN17 | 100 |
--------------------------------------------------------------------
Do anyone have Idea of VBA how to do this with multiple select from list OR one by one click entry from userform listbox
Thanks