Can someone help? (urgently needed)

[rainx]

Hi, I have a problem here, I have a list of entries of which has different group names. I need to sort them into various files based on their group name. In a way, doing filter, However, my concern is my group names will vary every month and I also need the files to be save respectively at a place with their group name. Kinda tough, Hope someone would be able to provide some advice. Wondering if it can just filter those that are in the list into different files instead of providing a fixed list to do for all each time. Please Help!

Thanks!
<!-- / message --> <!-- sig --> __________________
Cheers
Rainx

 

[rainx]

not working.. the 5 rows of header dun appear for the other split sheets, one sheet came out but den only the fifth row appear below the data...

Thanks!

 

[jindon]

Yeah, should be

        ws.Rows("1:5").Value = myHeadings
        ws.Cells(6,1).Resize(UBound(w,2), UBound(w,1)).Value = _
            Application.Transpose(w)

 

[rainx]

THANKS! WORK WELL!!!

thanks alot...