Macro for selecting lines

Hello,

please i need help for a macro.

I have a list with a column named "ticket id". I want the macro to filter the list and copy all rows containing same ticket id. What I need to have done is to select lines with same "ticket id" so as to paste them on another sheet, and then repeat the procedure until I have copied and pasted somewhere else all the rows from the list, but always grouping the rows that have same "ticket id".

Can anyone please help me?

Thanks in advance,

diegg