Macro for selecting lines [Closed]

Diegg - Apr 3, 2009 at 06:38 AM - Latest reply: bhawkins 5 Posts Saturday April 4, 2009Registration date April 6, 2009 Last seen
- 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
See more 

1 reply

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