Sorting in Excel VBA

Hi all,

well i'm just need a simple help or any hint for this case

i need to go through the active opened excel file then look for any Row start with "Subject" or any other defined words previously with match case then copy the content to opposite cell to a new .xlsx file at the same path on range (A2) and sort the all other records under it


"Subject" -----> (A2) and sort the rest under it
"German" -----> (B2) and sort the rest under it
"English" -----> (C2) and sort the rest under it
.
.
......etc

as shown below on screenshot


http://imgur.com/a/WsyKz


any help or advise please??

Thanks in advance

Cheers

Ethen


Cross-posting: http://www.vbaexpress.com/forum/show...222#post356222