Macro for selecting lines

Closed
Diegg - Apr 3, 2009 at 06:38 AM
bhawkins Posts 5 Registration date Saturday April 4, 2009 Status Member Last seen April 6, 2009 - Apr 5, 2009 at 07:46 AM
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

1 response

bhawkins Posts 5 Registration date Saturday April 4, 2009 Status Member Last seen April 6, 2009 10
Apr 5, 2009 at 07:46 AM
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.
0