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".
Hi, is the ticket id a number or a string, is the macro necessary (meaning is it supposed to work like an application). if it is numbers u could simply sort the column ascending or descending therefore grouping the rows with the same ticket id.