• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to create table with multiple criteria merged

Jassi2006

New Member
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
 
Top